Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 37
Within Azure Synapse Link for Azure Cosmos DB, which Column-oriented store is optimized for queries?
-
A
Cosmos DB store
-
B
Analytical store
-
C
Transactional store
-
D
Query store
Reveal correct answer
Correct answer: B
Explanation
An analytical store is a data store optimized for analytical queries.
A. The Cosmos DB store refers to the primary storage within Azure Cosmos DB, where all data is stored. While it is the main storage for data, it is not specifically optimized for queries like the Analytical store, making it less suitable for efficient querying in analytical workloads.
B. The Analytical store within Azure Synapse Link for Azure Cosmos DB is specifically optimized for queries. It allows for efficient querying and analysis of data stored in Azure Cosmos DB, making it the ideal choice for analytical workloads.
C. The Transactional store in Azure Synapse Link for Azure Cosmos DB is optimized for transactional processing and managing transactional data. It is not specifically designed for optimized querying of data, making it less suitable for analytical workloads.
D. The Query store is not a specific feature within Azure Synapse Link for Azure Cosmos DB. It is not optimized for queries and does not provide the same level of query performance as the Analytical store, making it less suitable for efficient querying in analytical workloads.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
