An organization is evaluating Microsoft Azure database offerings to support different workloads. Match each Azure database service on the left to the description on the right that best represents its characteristics or engine support.
- Azure SQL DatabaseA fully managed relational database service based on the Microsoft SQL Server engine with built-in high availability.
- Azure Cosmos DBA globally distributed NoSQL database service that supports schema-free data and provides multiple APIs.
- Azure Database for PostgreSQLA fully managed relational database service based on an open-source engine, suitable for open-source application migrations.
Answer
Azure SQL Database matches the description of a fully managed relational database service based on the Microsoft SQL Server engine. Azure Cosmos DB matches the description of a globally distributed NoSQL database service. Azure Database for PostgreSQL matches the description of a fully managed relational database service based on an open-source engine.
Azure SQL Database is built on the proprietary SQL Server engine. Azure Cosmos DB is a globally distributed NoSQL service supporting key-value, document, and graph models. Azure Database for PostgreSQL is an open-source relational service.
Step-by-Step Solution
Key Concept
Differentiating Azure database offerings by their relational vs. non-relational models and engine types.