Question 1

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?

Accepted Answer

Look for the keywords: 'SQL Server Agent', 'cross-database queries', and 'PaaS'. Managed Instance is the only PaaS option supporting these.

Question 2

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

Accepted Answer

Choosing SQL Server on VMs. While it works, it violates the requirement to use a PaaS solution to minimize administrative overhead.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam