Microsoft Azure Data Engineer (DP-203) Practice Test 2025 – Complete Exam Prep

To query an existing analytical store in Azure Cosmos DB using a Spark pool in Azure Synapse Analytics, creating a linked service for the Azure Cosmos DB database is essential. A linked service acts as a connection string that provides the necessary configuration information for Synapse to access external data sources. In this case, it facilitates communication between the Spark pool and the Azure Cosmos DB analytical store, allowing you to execute queries and process data effectively.

Establishing a linked service includes specifying details such as the type of data store, connection strings, authentication methods, and other options necessary for accessing the data within the analytical store. This step is fundamental before any actual querying can take place, as it enables Spark to understand how to connect to the Cosmos DB and retrieve the desired datasets.

In contrast, configuring a new security role, disabling automatic pausing, or setting up a virtual network do not address the core requirement of establishing a connection between Azure Synapse Analytics and Azure Cosmos DB for querying purposes. Each of these options may have their own relevance in different contexts or scenarios, but they do not provide the direct linkage necessary for querying an analytical store in this specific situation.