DP-900 - Identify Considerations for Relational Data on Azure (23% of the exam) - 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
lock_openFree 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 optioncheck_circle 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.
Exam traps in Identify Considerations for Relational Data on Azure
Answers that look right on this material and are not. Each one is a distractor from a different question in the DP-900 bank for this domain.
They support only key-value NoSQL access and cannot run standard relational SQL queries
errorWhy it is wrong: Azure Database for MySQL and PostgreSQL run the native relational engines and fully support standard SQL queries, so they are not key-value NoSQL stores.
Azure SQL Database, the fully managed PaaS service designed for new cloud solutions
errorWhy it is wrong: Azure SQL Database is fully managed and does not give administrative access to the operating system, so it cannot satisfy the requirement for OS-level control.
SQL Server on Azure Virtual Machines, so the team keeps full responsibility for patching the operating system
errorWhy it is wrong: Running SQL Server on a VM means you must manage OS and SQL Server updates yourself, which does not meet the requirement to offload maintenance to Microsoft.