DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
A company migrating on-prem SQL Server needs near-100% compatibility — SQL Agent jobs, cross-database queries, CLR — while staying PaaS. Which service?
A.Azure SQL Database (single database)
Single DB lacks Agent/cross-DB features.
B.Azure SQL Managed Instance
Instance-level PaaS = Managed Instance. Correct.
C.Azure Database for PostgreSQL
Different engine — no SQL Server compatibility.
D.Azure Synapse SQL pools
Synapse is analytics — not OLTP migration target.
Why this answer
Managed Instance = instance-scoped PaaS with ~near-complete SQL Server compatibility (Agent, linked servers, CLR, cross-DB queries) — the lift-and-shift target. Single-database Azure SQL DB lacks instance-level features.
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