ExamworthyExamworthy
Open the appStart free

DP-900 - Identify Considerations for Relational Data on Azure - Section 2.2

Describe relational Azure data services including the Azure SQL family and Azure Database for open-source engines.

Describe the Azure SQL family - Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs - and the open-source managed engines Azure Database for PostgreSQL and Azure Database for MySQL. Distinguish the level of management responsibility and compatibility each option provides.

Azure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure VMsAzure Database for PostgreSQLAzure Database for MySQL

Practice question for this objective

Free sampleIdentify Considerations for Relational Data on Azureeasy

Which of the following is one of the SQL Server based services that make up the Azure SQL family?

  • AAzure Database for PostgreSQL, a managed open-source relational option
  • BAzure Database for MySQL, a managed open-source relational option
  • CAzure Cosmos DB, a globally distributed non-relational option
  • DAzure SQL Managed Instance, a platform-as-a-service relational option Correct
The Azure SQL family is the set of SQL Server based services: SQL Server on Azure VMs, Azure SQL Managed Instance, and Azure SQL Database. Azure SQL is the collective term for Microsoft SQL Server based database services, and Azure SQL Managed Instance is one of its three members alongside SQL Server on Azure VMs and Azure SQL Database.

Why A is wrong: Azure Database for PostgreSQL is an Azure service for an open-source engine, not a member of the SQL Server based Azure SQL family.

Why B is wrong: Azure Database for MySQL runs the open-source MySQL engine and sits outside the SQL Server based Azure SQL family.

Why C is wrong: Azure Cosmos DB is a non-relational service and is not part of the SQL Server based Azure SQL family.

Why D is correct: Correct. Azure SQL is the collective term for Microsoft SQL Server based database services, and Azure SQL Managed Instance is one of its three members alongside SQL Server on Azure VMs and Azure SQL Database.

See more DP-900 practice questions, answers explained.

More in this domain

Back to all Identify Considerations for Relational Data on Azure objectives, or the DP-900 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.