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 questionsAzure 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.
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.
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”.
Keep practicing
Take the free DP-420 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DP-420 practice questions
- Question 1You have an Azure Cosmos DB for NoSQL account. You need to create an Azure Monitor query …
- Question 3You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an A…
- Question 6You are troubleshooting the current issues caused by the application updates. Which actio…
- Question 12You need to create a data store for a directory of small and medium-sized businesses (SMB…
- Question 13You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Cor…
- Question 16You configure multi-region writes for account1. You need to ensure that App1 supports the…
