Question 1

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?

Accepted Answer

Look for 'SQL Server Agent' and 'cross-database queries' combined with 'PaaS' (minimize overhead). This always points to Managed Instance.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Choosing Azure SQL Database, forgetting that it lacks instance-level features like SQL Agent.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4

More questions from this exam