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 elastic pool

  Why it's wrong here

  Azure SQL Database elastic pool is a PaaS option for scaling and sharing resources among multiple databases, but it operates at the server/database level, not at the instance level. It does not support cross-database queries using three-part names, SQL Server Agent, or other instance-scoped features such as Service Broker and database mail. While it can consolidate databases and manage fluctuating workloads, it fails to meet the requirement for instance-level functionality, so it is the wrong choice for these 15 on-premises databases.

  When this WOULD be correct

  A company has multiple small databases (e.g., under 2 GB each) with low and variable usage patterns, and they do not require cross-database queries or SQL Agent. They want to minimize cost and get built-in high availability. An elastic pool would be correct.

• ✗

  Azure SQL Database single database

  Why it's wrong here

  Azure SQL Database (single database) is a fully managed PaaS service that isolates each database, giving you per-database resource management and high availability. However, a single database cannot natively query other databases via three-part names, and it lacks SQL Server Agent at an instance level—scheduling would require elastic jobs or external tools. Since the scenario involves 15 databases that likely need to interact as a single instance, this option is unsuitable because it provides only database-scoped features, not instance-scoped ones.

  When this WOULD be correct

  A scenario where an application uses a single database (no cross-database queries) and does not require SQL Server Agent, such as a new cloud-native app with independent databases, and the goal is to minimize cost and management overhead.

• ✓

  Azure SQL Managed Instance

  Why this is correct

  Azure SQL Managed Instance is the correct choice because it is a PaaS offering that provides near-100% compatibility with on-premises SQL Server, including instance-level features such as cross-database queries using three-part names, SQL Server Agent, linked servers, and CLR. You get the administrative benefits of Azure (automated backups, patching, and high availability) without sacrificing the instance-scoped functionality these 15 databases likely rely on. This makes it ideal for lift-and-shift migrations where you need reduced overhead but full SQL Server instance behavior.

• ✗

  SQL Server on Azure Virtual Machines

  Why it's wrong here

  SQL Server on Azure Virtual Machines is an IaaS service that offers full control and complete SQL Server functionality, including cross-database queries and SQL Server Agent. However, because it is IaaS, you are responsible for managing the operating system, applying SQL Server and Windows patches, configuring backups, and setting up high availability—all of which increase administrative overhead. This directly contradicts the stated goal of reducing administrative tasks, making it an incorrect option even though it technically supports all required features.

  When this WOULD be correct

  This option is correct when the question specifies a need for full control over the SQL Server environment, such as requiring custom configurations, third-party agents, or legacy dependencies that are not supported in PaaS offerings, and when the team is willing to handle OS and SQL Server maintenance.

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