Examkin

Question

Difficulty: EasyAzure Database Services (Relational, Non-Relational, and Cosmos DB)

Match each Microsoft Azure database service to its primary description. To answer, drag the appropriate service from the column on the left to its description on the right.

  • Azure SQL DatabaseA fully managed relational database service based on the Microsoft SQL Server engine.
  • Azure Cosmos DBA globally distributed NoSQL database service that supports multiple APIs including MongoDB and Gremlin.
  • Azure Database for PostgreSQLA fully managed relational database service based on an open-source community engine, ideal for migrating existing PostgreSQL workloads.

Answer

Azure SQL Database matches with the Microsoft SQL Server engine description; Azure Cosmos DB matches with the globally distributed NoSQL service description; Azure Database for PostgreSQL matches with the fully managed community PostgreSQL engine description.
Azure SQL Database uses the Microsoft SQL Server engine; Azure Cosmos DB is a globally distributed NoSQL database supporting various APIs; Azure Database for PostgreSQL is an open-source relational database service.

Step-by-Step Solution

1
Identify the core database type (relational vs. non-relational) for each service.
Azure SQL Database and Azure Database for PostgreSQL are relational, while Azure Cosmos DB is non-relational (NoSQL).
This classification immediately isolates Azure Cosmos DB to the NoSQL description.
2
Distinguish between the two relational database engines based on their underlying platform.
Azure SQL Database is based on proprietary SQL Server, while Azure Database for PostgreSQL uses the open-source community PostgreSQL engine.
This resolves the remaining matches for the relational services.

Key Concept

Azure Database Services (Relational, Non-Relational, and Cosmos DB)
Estimated Time:1m 0s
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic