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 Database

  Why it's wrong here

  Azure SQL Database is wrong because it is a single-database PaaS offering that does not support SQL Server Agent, and cross-database queries are not supported within the same logical server unless using elastic query or external tables. Although it reduces management overhead, the lack of these on-premises SQL Server features would break existing functionality like scheduled jobs. Therefore, it is not a suitable migration target for a database that relies on agent jobs or cross-database logic.

  When this WOULD be correct

  An exam scenario where the company needs a fully managed PaaS database with built-in high availability and elastic scaling, but does not require SQL Server Agent or cross-database queries, and can accept a single database model.

• ✓

  Azure SQL Managed Instance

  Why this is correct

  Azure SQL Managed Instance is the correct choice because it provides near 100% surface area compatibility with on-premises SQL Server, including SQL Server Agent, linked servers, and cross-database queries within the same instance. As a Platform-as-a-Service (PaaS) offering, it handles patching, backups, and high availability automatically, which directly satisfies the requirement to minimize management overhead during migration. This makes it ideal for a 500 GB database with dependency on SQL Server-specific features.

• ✗

  SQL Server on Azure Virtual Machine

  Why it's wrong here

  SQL Server on Azure Virtual Machine is wrong because it is an Infrastructure-as-a-Service (IaaS) solution where the company must still manage the operating system, SQL Server installation, patching, and backups. While it provides full SQL Server compatibility and supports SQL Server Agent and cross-database queries, this approach increases management overhead rather than minimizing it. Thus, it fails the core business requirement of reducing administrative burden.

  When this WOULD be correct

  This option would be correct if the question required full control over the SQL Server environment, including custom configurations, specific SQL Server versions, or third-party software installation, and the customer is willing to manage patching and backups.

• ✗

  Azure Database for MySQL

  Why it's wrong here

  Azure Database for MySQL is wrong because it is a different database engine entirely, not a SQL Server offering. It does not support SQL Server-specific features such as SQL Server Agent, T-SQL syntax, or cross-database queries in the same manner as SQL Server. Migrating a SQL Server database to MySQL would require extensive schema and application code changes, making it impractical for a lift-and-shift migration of a 500 GB on-premises SQL Server database.

  When this WOULD be correct

  A company is migrating a 500 GB on-premises MySQL database to Azure and needs a PaaS service with minimal management overhead for patching and backups, while preserving MySQL-specific features like stored procedures and scheduled events. Azure Database for MySQL would be the correct choice.

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?”

Go deeper

Related to this question