Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company plans to migrate an on-premises payroll application to Azure. The application uses a 4 TB SQL Server 2012 database that relies on SQL Server Agent jobs, cross-database queries, and several SSIS packages. The business wants to minimize administrative overhead by adopting a platform-as-a-service option when possible, while preserving existing functionality and requiring only minor code changes. Which Azure data platform should you recommend for the database during the migration?
Azure SQL Managed Instance provides near-complete SQL Server engine compatibility, including support for SQL Server Agent, cross-database queries, and integration with SSIS through Azure Data Factory. It offers automated patching, backups, and built-in high availability as a fully managed PaaS service, minimizing administrative effort. Azure SQL Database (General Purpose or Hyperscale) lacks SQL Server Agent and true cross-database support, requiring significant re-engineering. Running SQL Server in an Azure virtual machine maintains full feature compatibility but shifts maintenance tasks such as OS patching and backups back to the customer, contradicting the goal of minimizing administration.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why is Azure SQL Managed Instance preferred over Azure SQL Database for this scenario?
Open an interactive chat with Bash
What role does SQL Server Agent play in this migration decision?
Open an interactive chat with Bash
How does Azure SQL Managed Instance minimize administrative overhead compared to running SQL Server on a virtual machine?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design infrastructure solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .