Match each Azure database service to its type.
Drag a concept onto its matching description — or click a concept then click the description.
Managed relational SQL database
Globally distributed NoSQL database
Managed MySQL database
Managed PostgreSQL database
In-memory data cache
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Azure SQL Database: Relational
In this matching exercise, the correct pairs are: Azure SQL Database (Relational), Azure Cosmos DB (NoSQL), Azure Database for MySQL (Relational), Azure Database for PostgreSQL (Relational). The distractors swap the types, incorrectly labeling Cosmos DB as relational and SQL Database as NoSQL.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Azure SQL Database: Relational
Why this is correct
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational database based on SQL Server. It offers built-in high availability, automated backups, and dynamic scalability while preserving the classic relational model of tables, constraints, and T-SQL queries.
Azure Cosmos DB: NoSQL
Why this is correct
Azure Cosmos DB is a globally distributed, multi-model NoSQL database that supports document, key-value, wide-column, and graph data models. It provides single-digit-millisecond read and write performance with multiple consistency levels, and its flexible schema makes it fundamentally non-relational.
Azure Database for MySQL: Relational
Why this is correct
Azure Database for MySQL is a managed relational database service built on MySQL Community Edition. It maintains a schema-based structure with tables, foreign keys, and reusable SQL queries, while also providing automated monitoring, security patching, and high availability.
Azure Database for PostgreSQL: Relational
Why this is correct
Azure Database for PostgreSQL is a managed relational database service that remains fully compatible with open-source PostgreSQL. It delivers the relational model with ACID transactions, advanced indexing, and SQL features, plus built-in high availability and automated backups.
Azure Cosmos DB: Relational
Why it's wrong here
This pairing is incorrect because Azure Cosmos DB is intentionally designed as a horizontally scalable NoSQL system, not a relational database. It does not enforce fixed table schemas or rely on relational joins; instead, it stores schema-less items, such as JSON documents, in containers.
Azure SQL Database: NoSQL
Why it's wrong here
This pairing is incorrect because Azure SQL Database runs on the SQL Server relational engine, which enforces a fixed schema, primary and foreign keys, and robust join operations. It does not implement NoSQL concepts like flexible documents or horizontal sharding of a data store, so it cannot be classified as NoSQL.
Go deeper
Learn chapter
Azure Cost Management and Billing
Key term
Azure Cosmos DB
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service that offers fast reads and writes anywhere in the world with automatic scaling and multiple consistency models.
Key term
Azure Database for PostgreSQL
Azure Database for PostgreSQL is a fully managed, scalable relational database service in Microsoft Azure that runs the open-source PostgreSQL engine, handling backups, patching, and high availability for you.
About these practice questions
One of 981 original AZ-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.