DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
An app requires a specific SQL Server version plus custom OS-level agents on the database server — unsupported by any PaaS tier. Which deployment option allows full control?
A.Azure SQL Database
PaaS single database — no OS access.
B.SQL Server on Azure Virtual Machines
Full control requires IaaS VM. Correct.
C.Azure SQL Managed Instance
MI is still PaaS — no OS-level customization.
D.Azure Database for MySQL
Wrong engine AND PaaS.
Why this answer
IaaS (SQL Server on VMs) = full control: any version, OS-level access, custom agents/extensions — at the cost of managing patching/HA yourself. PaaS options remove control for convenience.
Correct answer: B · 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