dp-900 Practice Question 1811
Exam: dp-900
Domain: Describe core data concepts
Topic: Describe types of data
Difficulty: medium
During a performance review, you notice that the semi-structured JSON data stored in Azure Blob Storage is not being queried efficiently due to the lack of schema enforcement. What Azure service should you recommend to improve query performance by enforcing a schema and allowing for more efficient querying of semi-structured data?
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 allows you to define a schema for your semi-structured JSON data, which improves query performance and enables more efficient querying. Option A (Azure SQL Database) is not suitable for semi-structured data as it requires a fixed schema. Option C (Azure Blob Storage) does not provide any schema enforcement or advanced querying capabilities. Option D (Azure Table Storage) is designed for NoSQL key-value pairs and does not support semi-structured data or schema enforcement.