Skip to main content
  1. Public practice questions
  2. AZ-900 Practice Exams | Azure Fundamentals
  3. Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

Question 6 — Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

For each Azure Database Service listed below the table, drag it to the appropriate boxes in the Correct Match column to match it against its Description in the Option Column.

Option Correct Match
A fully managed relational database solution for structured data [Gap 1]
A NoSQL database designed for global-scale applications [Gap 2]
A cloud-based data warehouse used for querying massive datasets [Gap 3]
A highly scalable data storage solution for analytics workloads [Gap 4]
Ideal for applications requiring ACID transactions and strong consistency [Gap 5]
Optimized for applications that require flexible and schema-free data storage [Gap 6]
Enables business intelligence teams to visualize and query data efficiently [Gap 7]
Often used as a central repository for massive amounts of raw data [Gap 8]
  1. Azure Data Lake
  2. Azure SQL Database
  3. Azure Synapse Analytics
  4. Azure Cosmos DB

Correct answers

  1. Gap 1: Azure SQL Database
  2. Gap 2: Azure Cosmos DB
  3. Gap 3: Azure Synapse Analytics
  4. Gap 4: Azure Data Lake
  5. Gap 5: Azure SQL Database
  6. Gap 6: Azure Cosmos DB
  7. Gap 7: Azure Synapse Analytics
  8. Gap 8: Azure Data Lake

Explanations

Azure SQL Database: A managed relational database service designed for structured data with ACID (Atomicity, Consistency, Isolation, Durability) transactions. It is ideal for transactional applications that require strict data consistency, such as financial records and user authentication systems.

Azure Cosmos DB: A NoSQL database solution optimized for high availability, scalability, and low-latency global applications. Unlike Azure SQL, it allows flexible schema designs and is suitable for scenarios requiring fast, large-scale data processing, such as real-time recommendation systems.

Azure Synapse Analytics: A cloud-based data warehouse solution that allows businesses to perform large-scale data queries and analysis. It is optimized for business intelligence and reporting, making it useful for analyzing historical customer trends and operational data.

Azure Data Lake: A highly scalable data storage solution used for storing vast amounts of raw data. It acts as a central repository for structured, semi-structured, and unstructured data, supporting analytics workloads such as machine learning and big data processing.