dp-900 Practice Question 1814

Exam: dp-900
Domain: Describe core data concepts
Topic: Describe types of data
Difficulty: medium
Contoso Ltd wants to implement a solution that can handle both structured and semi-structured data, ensuring that the data is stored and queried efficiently. They also require a service that can scale horizontally and provide high availability. Which Azure service should they choose to meet these requirements?

Answer Options

A
Azure SQL Database
B
Azure Cosmos DB
C
Azure Blob Storage
D
Azure Table Storage

Correct Answer

B: Azure Cosmos DB

Explanation

The correct answer is B: Azure Cosmos DB. Azure Cosmos DB can handle both structured and semi-structured data, providing efficient querying and scaling capabilities. Option A (Azure SQL Database) is limited to structured data and does not support semi-structured data. Option C (Azure Blob Storage) is not suitable for querying semi-structured data efficiently. Option D (Azure Table Storage) is designed for NoSQL key-value pairs and does not support semi-structured data or complex querying.