ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam
Go to Exam

Exam DP-420 topic 5 question 17 discussion

Actual exam question from Microsoft's DP-420
Question #: 17
Topic #: 5
[All DP-420 Questions]

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.

  • A. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.
  • 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.
  • E. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by TRUESON at May 1, 2023, 1:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
3709334
3 months, 3 weeks ago
Selected Answer: AD
answer provided is correct
upvoted 1 times
...
azuredemo2022three
10 months ago
Selected Answer: AD
Selected Answer: AD
upvoted 3 times
...
azuredemo2022three
10 months ago
Answer A and D
upvoted 1 times
azuredemo2022three
10 months ago
A. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source: By creating a table in an Apache Spark pool in Azure Synapse that uses the cosmos.olap data source, you can efficiently access and analyze the data stored in your Azure Cosmos DB account. This approach leverages the optimized capabilities of Apache Spark and allows you to perform machine learning tasks on the data. D. Enable Azure Synapse Link for the account and Analytical store on the container: Enabling Azure Synapse Link for your Azure Cosmos DB account and enabling the Analytical store on the container provides seamless integration between Azure Cosmos DB and Azure Synapse Analytics. It allows you to load and analyze data from Azure Cosmos DB using Apache Spark in Azure Synapse Analytics without impacting the performance of your web apps.
upvoted 2 times
...
...
imando
10 months, 1 week ago
Why not E ?
upvoted 1 times
WimTS
3 days, 12 hours ago
cosmos.oltp connects to the transactional store, cosmos.olap connects to the analytical store.
upvoted 1 times
...
...
TRUESON
11 months, 3 weeks ago
Might be correct https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago