ExpertEasy1 markMultiple Choice
AZ-305 · Question 19 · Domain 2.1: Relational Data Storage
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?
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?
Answer options:
A.
Azure SQL Database
B.
Azure SQL Managed Instance
C.
SQL Server on Azure Virtual Machines
D.
Azure Synapse Analytics
How to approach this question
Look for requirements that demand OS-level access. Any requirement for OS access immediately rules out PaaS solutions.
Full Answer
C.SQL Server on Azure Virtual Machines✓ Correct
SQL Server on Azure Virtual Machines
The requirement to install custom third-party agents on the underlying operating system mandates an Infrastructure as a Service (IaaS) solution. Azure SQL Database and Azure SQL Managed Instance are Platform as a Service (PaaS) offerings; Microsoft manages the OS, and you cannot log into it or install OS-level agents. Therefore, SQL Server on Azure Virtual Machines is the only viable option.
Common mistakes
Choosing Managed Instance because it supports MSDTC. While true, candidates miss the 'OS agent installation' requirement, which strictly requires IaaS.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard