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.
| Item | True | 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
- Azure SQL Database supports ACID transactions. → True
- Azure Cosmos DB supports multi-region replication → True
- Azure Synapse Analytics is used for storing unstructured data → False
- 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