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 118 — Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

For each statement below, indicate whether the Answer is True or False.

Response matrix
ItemTrue False
Azure SQL Database supports ACID transactions. □□
Azure Cosmos DB supports multi-region replication □□
Azure Synapse Analytics is used for storing unstructured data □□
Azure Data Lake is primarily used for structured transactional data □□

Correct answers

  1. Azure SQL Database supports ACID transactions. → True
  2. Azure Cosmos DB supports multi-region replication → True
  3. Azure Synapse Analytics is used for storing unstructured data → False
  4. Azure Data Lake is primarily used for structured transactional data → False

Explanations

True: Azure SQL Database supports ACID transactions.
ACID transactions ensure data integrity and consistency, making SQL databases ideal for applications like banking and e-commerce.

True: Azure Cosmos DB supports multi-region replication.
Cosmos DB is designed for globally distributed applications, providing automatic multi-region replication for high availability.

False: Azure Synapse Analytics is used for storing unstructured data.
Synapse Analytics is a data warehouse optimized for querying and analyzing structured and semi-structured data, not raw unstructured data storage.

False: Azure Data Lake is primarily used for structured transactional data.
Data Lake is designed for storing massive amounts of structured, semi-structured, and unstructured data, making it suitable for analytics and big data processing rather than transactional applications.

Azure SQL Database supports ACID transactions.

Azure Cosmos DB supports multi-region replication

Azure Synapse Analytics is used for storing unstructured data

Azure Data Lake is primarily used for structured transactional data