dp-900 Practice Question 1813
Exam: dp-900
Domain: Describe core data concepts
Topic: Describe types of data
Difficulty: medium
Contoso Ltd is experiencing issues with data consistency across their distributed systems. They need a solution that ensures data integrity and maintains ACID properties during transactions. Which Azure service should they use to address these requirements?
Answer Options
A
Azure Cosmos DB
B
Azure SQL Database
C
Azure Service Fabric
D
Azure App Service
Correct Answer
B: Azure SQL Database
Explanation
The correct answer is B: Azure SQL Database. Azure SQL Database supports ACID transactions, ensuring data integrity and consistency across distributed systems. Option A (Azure Cosmos DB) does not guarantee ACID transactions for all workloads. Option C (Azure Service Fabric) is a distributed system platform but does not inherently provide ACID transactions. Option D (Azure App Service) is a web application hosting service and does not support ACID transactions.