DP-900 Practice Question: Identify considerations for relational data on Azure

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Azure SQL Managed Instance

  Why this is correct

  Azure SQL Managed Instance is the correct choice because it offers near-total parity with on-premises SQL Server, preserving critical features like SQL Server Agent and three-part cross-database queries, which are essential for a seamless lift-and-shift of a 3 TB transactional database. Its instance-level scope allows multiple databases to reside on the same logical server, enabling in-database queries across those databases without application rewrites. Being fully managed, it handles patching, backups, and high availability, making it the ideal target for this migration.

• ✗

  Azure SQL Database (single database)

  Why it's wrong here

  Azure SQL Database (single database) is wrong because it lacks server-level constructs, so three-part names such as Database1.schema.table fail, and SQL Server Agent is absent, which prevents native execution of scheduled jobs and maintenance tasks that the current SQL Server likely uses. Running a 3 TB database with cross-database dependencies would force re-architecting the solution to use elastic query or external data sources, introducing substantial modifications to application code and increasing migration complexity. This makes it unsuitable for a straightforward migration.

  When this WOULD be correct

  A company needs a fully managed PaaS database for a new application with no cross-database dependencies and no need for SQL Agent. They want automatic backups and patching, and the application uses simple single-database connections.

• ✗

  Azure SQL Database (elastic pool)

  Why it's wrong here

  Azure SQL Database (elastic pool) is wrong because it is merely a cost-optimization layer that groups multiple single databases to share a fixed pool of vCores and storage; it does not change the underlying engine capabilities of Azure SQL Database. Therefore, it inherits the same restrictions as the single database option: no SQL Server Agent and no three-part cross-database queries, meaning the 3 TB database would still need application changes. While elastic pools are useful for scaling many low-activity databases, they do not address the compatibility requirements of this migration, making them an incorrect target.

  When this WOULD be correct

  A company needs to manage multiple databases with varying and unpredictable usage patterns, wanting to optimize cost by sharing resources among databases while still getting automatic backups and patching. They do not require cross-database queries or SQL Agent.

• ✗

  Azure Synapse Analytics dedicated SQL pool

  Why it's wrong here

  Azure Synapse Analytics dedicated SQL pool is wrong for this transactional workload because it is a distributed, Massively Parallel Processing (MPP) engine designed for analytical queries over large volumes of data, not for OLTP operations with frequent, small transactions. It lacks SQL Server Agent, so scheduled jobs cannot run, and its architecture does not support three-part cross-database queries in the same way, as each database is a separate compute boundary. Performing high-frequency inserts, updates, and deletes would suffer from latency and throughput bottlenecks, so it cannot replace the source SQL Server instance.

  When this WOULD be correct

  This option would be correct for a question about migrating a large data warehouse (e.g., 10+ TB) for analytics and reporting, where the workload is read-intensive, uses PolyBase for data integration, and does not require cross-database queries or SQL Server Agent. The question would emphasize petabyte-scale data and high concurrency for complex queries.

Option-by-option analysis

Why each answer is right or wrong

Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.

Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”