Exam AZ-301 topic 17 question 12 discussion

Actual exam question from Microsoft's AZ-301

Question #: 12
Topic #: 17

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2012 R2 instances. The instances host databases that have the following characteristics:
✑ The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
✑ Stored procedures are implemented by using CLR.
You plan to move all the data from SQL Server to Azure.
You need to recommend an Azure service to host the databases. The solution must meet the following requirements:
✑ Whenever possible, minimize management overhead for the migrated databases.
✑ Minimize the number of database changes required to facilitate the migration.
Ensure that users can authenticate by using their Active Directory credentials.

What should you include in the recommendation?

A. Azure SQL Database single databases
B. Azure SQL Database Managed Instance
C. Azure SQL Database elastic pools
D. SQL Server 2016 on Azure virtual machines

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance

by Ekramy_Elnaggar at Jan. 16, 2020, 2:04 p.m.

Comments

Submit Cancel

Ekramy_Elnaggar

Highly Voted 5 years, 5 months ago

This is a repeated question: https://www.examtopics.com/exams/microsoft/az-301/view/64/

upvoted 10 times

...

[Removed]

Highly Voted 4 years, 10 months ago

A. Azure SQL Database single databases > As we should minimize management overhead it wouldnt make sens to create a single DB for each of the on-premises DBs. So this can be ruled out. B. Azure SQL Database Managed Instance > Gen5 does support up to 8 TB per instance, and also stored procedures that run in CLR. So this is a good candidate. C. Azure SQL Database elastic pools > Would help to reduce cost, depending on the usage pattern of the DBs. However this is not an explicit requirement why I would discard it. D. SQL Server 2016 on Azure virtual machines > This would contradict with the requirement regardint the management overhead. We would have to install the VM(s), SQL Server, setup the DBs and so on. Conclusion: Answer B) seems to be correct. Links: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

upvoted 8 times

...

sanketshah

Most Recent 4 years, 5 months ago

B. Azure SQL Database Managed Instance

upvoted 1 times

...

chult

4 years, 10 months ago

Azure SQL Database does not support CLR

upvoted 1 times

...