dp-900 Practice Question 1810
Exam: dp-900
Domain: Describe core data concepts
Topic: Describe types of data
Difficulty: medium
Contoso Ltd is migrating its data storage from on-premises to Azure. They have a large dataset that includes structured data in CSV format, semi-structured data in JSON format, and unstructured images and videos. Which Azure service would you recommend for storing and querying the structured CSV data while ensuring it meets the ACID properties for transactional integrity?
Answer Options
A
Azure Cosmos DB
B
Azure SQL Database
C
Azure Blob Storage
D
Azure Table Storage
Correct Answer
B: Azure SQL Database
Explanation
The correct answer is B: Azure SQL Database. Azure SQL Database provides a relational database service that supports ACID transactions, which is essential for maintaining data integrity during transactions. It can efficiently store and query structured data like CSV files. Option A (Azure Cosmos DB) is not suitable for transactional workloads with ACID properties; it is more suited for NoSQL and document-based data models. Option C (Azure Blob Storage) is used for storing unstructured data but does not support transactional ACID properties. Option D (Azure Table Storage) is also not appropriate as it is designed for NoSQL key-value pairs and does not support ACID transactions.