DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
A company needs SQL Server features on their own VMs for full OS control including SQL Agent and linked servers. Which deployment option gives maximum control?
A.SQL Server on Azure Virtual Machines — IaaS, you manage the OS and SQL
IaaS = full control. Correct.
B.Azure SQL Database single database
Single DB PaaS has no Agent/linked-server parity.
C.Azure SQL Managed Instance
MI is close — but no OS-level access.
D.Azure Synapse SQL pool
Synapse is analytics — not OLTP.
Why this answer
The control ladder: SQL on VM (IaaS — full OS + all SQL Server features) > Managed Instance (PaaS, near-full SQL features, no OS) > SQL Database (PaaS, mainstream features only). 'Full OS control' = IaaS always.
Correct answer: A · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Relational Data on Azure practice session.
Practice Relational Data on Azure