Question 1

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?

Accepted Answer

Look for the intersection of 'PaaS benefits' (low overhead) and 'Instance-level SQL features' (SQL CLR, Service Broker).

Question 2

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

Accepted Answer

Choosing SQL on VMs because of the legacy features, ignoring the requirement to minimize OS management overhead.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam