ExpertHard1 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 currently 12 TB in size and is expected to grow by 2 TB annually. The application relies heavily on SQL Server Agent jobs, cross-database queries, and legacy Common Language Runtime (CLR) assemblies. The business requires a fully managed PaaS solution to minimize administrative overhead.
Which Azure data service should you recommend?
You are migrating an on-premises SQL Server database to Azure.
The database is currently 12 TB in size and is expected to grow by 2 TB annually. The application relies heavily on SQL Server Agent jobs, cross-database queries, and legacy Common Language Runtime (CLR) assemblies. The business requires a fully managed PaaS solution to minimize administrative overhead.
Which Azure data service should you recommend?
Answer options:
A.
Azure SQL Database Hyperscale
B.
Azure SQL Managed Instance
C.
SQL Server on Azure Virtual Machines
D.
Azure Synapse Analytics dedicated SQL pool
How to approach this question
Look for the keywords: 'PaaS', 'SQL Server Agent', 'cross-database queries', and 'CLR'. These strictly point to Managed Instance.
Full Answer
B.Azure SQL Managed Instance✓ Correct
Azure SQL Managed Instance
Azure SQL Managed Instance is the PaaS service designed for easy migration of on-premises SQL Server workloads. It supports instance-level features like SQL Server Agent, cross-database queries, Service Broker, and CLR assemblies, which are not supported in Azure SQL Database. It also supports databases up to 16 TB (depending on the service tier), accommodating the 12 TB requirement.
Common mistakes
Choosing Hyperscale because of the 12 TB size. While Hyperscale handles large data, it lacks the instance-level features required by the scenario.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard