DP-420 practice question 9 of 25

You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps. You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Full set: 144 questions
Answer options
A: In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source. Correct answer
B: Create a private endpoint connection to the account.
C: In an Azure Synapse Analytics serverless SQL pool, create a view that uses OPENROWSET and the CosmosDB provider.
D: Enable Azure Synapse Link for the account and Analytical store on the container. Correct answer
E: In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.
Correct Answer:
A. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.; D. Enable Azure Synapse Link for the account and Analytical store on the container.
Explanation

Azure Synapse Link isolates analytical workloads by replicating operational data into an analytical store. Enabling Synapse Link and Analytical store on the container (D) keeps OLTP traffic untouched. Apache Spark in Synapse can then read the analytical store via the cosmos.olap connector (A), providing near-real-time analytics without affecting the 10 production web apps.

Why Incorrect

B. Private endpoints secure connectivity but do not create an isolated analytical workload.
C. OPENROWSET reads via serverless SQL; not needed for Spark and may still hit OLTP without Synapse Link.
E. cosmos.oltp targets the transactional store directly, increasing load on the web-apps’ database.

References

1. Microsoft Docs – “Azure Synapse Link for Azure Cosmos DB”

section “Analytical store architecture & performance isolation” (https://learn.microsoft.com/azure/cosmos-db/synapse-link).

2. Microsoft Docs – “Run Apache Spark queries on analytical store”

step 3 “Create table using cosmos.olap” (https://learn.microsoft.com/azure/cosmos-db/synapse-link/how-to-spark-run-queries).

3. Microsoft Docs – Same article

“Near-real-time analytics without affecting your transactional workload”.

Scroll to Top