Question 1

A company is migrating a third-party vendor application to Azure.

The vendor explicitly states that the application requires sysadmin access to the database server, the ability to install custom third-party agents on the underlying operating system, and support for SQL Server Distributed Transaction Coordinator (MSDTC).

Which database solution MUST you use?

Accepted Answer

Look for requirements that demand OS-level access. Any requirement for OS access immediately rules out PaaS solutions.

Question 2

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

Accepted Answer

Choosing Managed Instance because it supports MSDTC. While true, candidates miss the 'OS agent installation' requirement, which strictly requires IaaS.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam