Explanation:
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:
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.
Ultimate access to all questions.
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.
No comments yet.