nerdexam
MicrosoftMicrosoft

AZ-305 · Question #26

AZ-305 Question #26: Real Exam Question with Answer & Explanation

Sign in or unlock AZ-305 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.

Submitted by weili_xi· Mar 6, 2026Design data storage solutions

Question

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

Options

  • AAzure SQL Database elastic pools
  • BAzure SQL Managed Instance
  • CAzure SQL Database single databases
  • DSQL Server 2016 on Azure virtual machines

Unlock AZ-305 to see the answer

You've previewed enough free AZ-305 questions. Unlock AZ-305 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full AZ-305 PracticeBrowse All AZ-305 Questions