ExpertMedium1 markMultiple Choice
AZ-305 · Question 20 · Domain 2.1: Relational Data Storage
You are designing the migration of an on-premises SQL Server database to Azure.
The database relies heavily on SQL Server Agent jobs for nightly batch processing, uses Service Broker for message queuing, and requires cross-database queries. You want to minimize administrative overhead and avoid managing the underlying operating system.
Which Azure data service should you recommend?
You are designing the migration of an on-premises SQL Server database to Azure.
The database relies heavily on SQL Server Agent jobs for nightly batch processing, uses Service Broker for message queuing, and requires cross-database queries. You want to minimize administrative overhead and avoid managing the underlying operating system.
Which Azure data service should you recommend?
Answer options:
A.
Azure SQL Database
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 'SQL Server Agent' and 'cross-database queries' combined with 'PaaS' (minimize overhead). This always points to Managed Instance.
Full Answer
B.Azure SQL Managed Instance✓ Correct
Azure SQL Managed Instance
Azure SQL Managed Instance is the ideal destination for migrating on-premises SQL Server databases that require instance-level features like SQL Server Agent, Service Broker, Database Mail, and cross-database queries. As a fully managed PaaS offering, it eliminates the need to manage the underlying OS and database software patching.
Common mistakes
Choosing Azure SQL Database, forgetting that it lacks instance-level features like SQL Agent.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4
55 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ04CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ05CASE STUDY: Tailspin Toys
Tailspin Toys is a global manufacturing company with 50,000 employees ...Hard