ExpertEasy1 markMultiple Choice
AZ-305 · Question 16 · Domain 2.1: Relational Data Storage
You are migrating an on-premises SQL Server database to Azure.
The database is 2 TB in size. The application relies heavily on SQL Server Agent jobs for nightly batch processing and uses cross-database queries between three different databases on the same instance.
You need to recommend a PaaS database solution that minimizes migration effort and administrative overhead.
Which service should you recommend?
You are migrating an on-premises SQL Server database to Azure.
The database is 2 TB in size. The application relies heavily on SQL Server Agent jobs for nightly batch processing and uses cross-database queries between three different databases on the same instance.
You need to recommend a PaaS database solution that minimizes migration effort and administrative overhead.
Which service should you recommend?
Answer options:
A.
Azure SQL Database (Single Database)
B.
Azure SQL Database (Elastic Pool)
C.
Azure SQL Managed Instance
D.
SQL Server on Azure Virtual Machines
How to approach this question
Look for the keywords: 'SQL Server Agent', 'cross-database queries', and 'PaaS'. Managed Instance is the only PaaS option supporting these.
Full Answer
C.Azure SQL Managed Instance✓ Correct
Azure SQL Managed Instance
Azure SQL Managed Instance is the correct choice. It is a fully managed PaaS database engine that provides near 100% compatibility with the latest SQL Server enterprise edition. Crucially, it supports instance-scoped features like SQL Server Agent, cross-database queries, and Service Broker, which are not supported in Azure SQL Database. SQL Server on VMs is IaaS, not PaaS.
Common mistakes
Choosing SQL Server on VMs. While it works, it violates the requirement to use a PaaS solution to minimize administrative overhead.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard