Data Engineering on Microsoft Azure — Question 71

You have an Azure subscription that contains an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos DB database account named Cosmos1. Cosmos1 contains a container named container1 and ws1 contains a serverless SQL pool.

You need to ensure that you can query the data in container1 by using 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.

Answer options

• 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.

Correct answer: A, C, D

Explanation

The correct steps are to enable Azure Synapse Link for Cosmos1, create a linked service in ws1 that references Cosmos1, and enable the analytical store for container1. Disabling the analytical store (option B) or indexing (option E) would hinder the ability to efficiently query the data, making them incorrect choices.