Examkin

Question

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

You are planning to migrate several application workloads to Microsoft Azure. Match each Azure database service to its primary database engine or classification description.

  • 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 open-source APIs.
  • Azure Database for PostgreSQLA fully managed relational database service based on the open-source community engine.

Answer

Azure SQL Database matches with the Microsoft SQL Server engine; Azure Cosmos DB matches with the globally distributed NoSQL database service; Azure Database for PostgreSQL matches with the relational service based on the open-source community engine.
Azure SQL Database matches the Microsoft SQL Server engine description because it is Microsoft's PaaS offering for SQL Server. Azure Cosmos DB is a multi-model NoSQL service that provides global scaling. Azure Database for PostgreSQL is the PaaS offering hosting the open-source community PostgreSQL database engine.

Step-by-Step Solution

1
Determine the database model (relational vs. non-relational) for each service.
Azure SQL Database and Azure Database for PostgreSQL are relational, whereas Azure Cosmos DB is non-relational (NoSQL).
Understanding the fundamental database type helps separate relational databases from NoSQL databases.
2
Differentiate between the relational database engines.
Azure SQL Database relies on the proprietary Microsoft SQL Server engine, while Azure Database for PostgreSQL uses the community open-source PostgreSQL engine.
This differentiation enables correct matching for the relational services.

Key Concept

Classification of Azure Relational and Non-Relational Databases
Rate this question

Topics

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

More questions from this topic