ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam
Go to Exam

Exam AZ-301 topic 3 question 4 discussion

Actual exam question from Microsoft's AZ-301
Question #: 4
Topic #: 3
[All AZ-301 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
by MyLord at Oct. 29, 2019, 11:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Oz
Highly Voted 5 years, 6 months ago
Key to the solution is mentioning of CLR (common language runtime). CLR is not supported for Single Database or Elastic pool. Which makes Managed Instance (and instance pools) the only correct answer
upvoted 39 times
...
MyLord
Highly Voted 5 years, 6 months ago
Quite helpful for this question https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
upvoted 11 times
tartar
4 years, 7 months ago
B is ok
upvoted 3 times
...
...
glam
Most Recent 4 years, 3 months ago
B. Azure SQL Database Managed Instance
upvoted 2 times
...
sanketshah
4 years, 4 months ago
B is correct answer.
upvoted 1 times
...
Yannor
4 years, 9 months ago
As i've seen with this questions and AZ-300 questions, almost every time it states "Minimize the number of database changes required to facilitate the migration" the answer is managed instances.
upvoted 4 times
KCjoe
4 years, 9 months ago
I don't understand, can you explain why it is not D if there is minimize number of changes, everything should be exactly the same if using VM
upvoted 1 times
satya22
4 years, 9 months ago
I guess due to management overhead as mentioned in criteria
upvoted 2 times
...
...
...
Baranli
4 years, 10 months ago
Answer is correct , here is the reference https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
upvoted 3 times
...
pandeya442
5 years ago
ans in correct
upvoted 1 times
...
starnb
5 years, 2 months ago
Instance Pools support CLR and can reduce management overhead. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
upvoted 4 times
starnb
5 years, 2 months ago
However, "Minimize the number of database changes required to facilitate the migration" makes Managed Instance the most suitable answer.
upvoted 6 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago