Skip to main content
  1. Public practice questions
  2. AZ-900 Practice Exams | Azure Fundamentals
  3. Domain 1-Describe cloud concepts | AZ-900 Practice Exam |170 Questions

Question 97 — Domain 1-Describe cloud concepts | AZ-900 Practice Exam |170 Questions

Fill in the blanks by selecting the correct options from the dropdown menus.

Azure provides multiple database and analytics services, including [Gap 1], which offers [Gap 2] data storage, and [Gap 3], which is a [Gap 4] database. For large-scale business intelligence, [Gap 5] is used, often in combination with [Gap 6] for storing massive datasets.

  1. structured
  2. Azure Data Lake
  3. Azure SQL Database
  4. Azure Synapse Analytics
  5. globally distributed NoSQL
  6. Azure Cosmos DB

Correct answers

  1. Gap 1: Azure SQL Database
  2. Gap 2: structured
  3. Gap 3: Azure Cosmos DB
  4. Gap 4: globally distributed NoSQL
  5. Gap 5: Azure Synapse Analytics
  6. Gap 6: Azure Data Lake

Explanations

Azure provides multiple database and analytics services, including Azure SQL Database, which offers structured data storage, and Azure Cosmos DB, which is a globally distributed NoSQL database. For large-scale business intelligence, Azure Synapse Analytics is used, often in combination with Azure Data Lake for storing massive datasets.

Correct:

Azure SQL Database Designed for structured relational data storage with strong consistency.
Structured Data is stored in predefined tables with rows and columns.
Azure Cosmos DB A NoSQL database that supports schema-free storage with high availability.
Globally distributed NoSQL Cosmos DB supports multi-region replication and scalability.
Azure Synapse Analytics Used for querying and analyzing structured datasets for business intelligence.
Azure Data Lake Stores massive amounts of raw and semi-structured data for analytics processing.