ExpertHard1 markMultiple Choice
AZ-305 · Question 16 · Domain 2.1: Relational Data Storage
A financial services company is migrating a legacy on-premises application to Azure. The application relies on a SQL Server database.
The database heavily utilizes SQL Server Common Language Runtime (SQL CLR) integration, Service Broker, and cross-database transactions. The company wants to minimize administrative overhead for OS patching and backups, but cannot rewrite the application code.
Which data storage solution should you recommend?
A financial services company is migrating a legacy on-premises application to Azure. The application relies on a SQL Server database.
The database heavily utilizes SQL Server Common Language Runtime (SQL CLR) integration, Service Broker, and cross-database transactions. The company wants to minimize administrative overhead for OS patching and backups, but cannot rewrite the application code.
Which data storage solution should you recommend?
Answer options:
A.
Azure SQL Database (Single Database)
B.
Azure SQL Managed Instance
C.
SQL Server on Azure Virtual Machines
D.
Azure SQL Database Elastic Pool
How to approach this question
Look for the intersection of 'PaaS benefits' (low overhead) and 'Instance-level SQL features' (SQL CLR, Service Broker).
Full Answer
B.Azure SQL Managed Instance✓ Correct
Azure SQL Managed Instance
Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service (PaaS). It natively supports instance-level features like SQL CLR, Service Broker, and cross-database queries, which are not available in Azure SQL Database.
Common mistakes
Choosing SQL on VMs because of the legacy features, ignoring the requirement to minimize OS management overhead.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard