
Answer-first summary for fast verification
Answer: Enable Azure Synapse Link for Cosmos1., In ws1, create a linked service that references Cosmos1., Enable the analytical store for container1.
To enable querying Azure Cosmos DB data from a serverless SQL pool in Azure Synapse Analytics, three key configuration steps are required: **A: Enable Azure Synapse Link for Cosmos1** - This establishes the integration between Azure Synapse Analytics and Azure Cosmos DB, allowing seamless data access and analytics capabilities across both services. **C: In ws1, create a linked service that references Cosmos1** - A linked service creates the connection configuration between the Synapse workspace and the Cosmos DB account, enabling authentication and data access for query operations. **D: Enable the analytical store for container1** - The analytical store provides a columnar representation of Cosmos DB data optimized for analytical queries, which is essential for efficient querying through the serverless SQL pool. **Why other options are incorrect:** - **B: Disable the analytical store for container1** - This would prevent analytical querying capabilities, contradicting the requirement to query data from the serverless SQL pool. - **E: Disable indexing for container1** - Indexing is crucial for query performance in Cosmos DB and disabling it would negatively impact query efficiency without providing any benefit for the analytical use case. These three actions together provide the complete foundation for querying Cosmos DB data through Synapse Analytics' serverless SQL pool while maintaining optimal performance and integration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have an Azure subscription containing an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos DB account named Cosmos1. Cosmos1 has a container named container1, and ws1 includes a serverless SQL pool.
You need to query the data in container1 from the serverless SQL pool.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A
Enable Azure Synapse Link for Cosmos1.
B
Disable the analytical store for container1.
C
In ws1, create a linked service that references Cosmos1.
D
Enable the analytical store for container1.
E
Disable indexing for container1.