New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-420 Exam - Topic 9 Question 46 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 46
Topic #: 9
[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.

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Lorean
3 months ago
C could work, but I prefer D for better performance.
upvoted 0 times
...
Patrick
3 months ago
Wait, can we really use OPENROWSET with CosmosDB? Sounds risky!
upvoted 0 times
...
Afton
3 months ago
I think B is unnecessary, private endpoints aren't needed here.
upvoted 0 times
...
Shawna
4 months ago
A seems right too, using cosmos.olap is smart.
upvoted 0 times
...
Luther
4 months ago
Definitely go with D for enabling Synapse Link!
upvoted 0 times
...
Barney
4 months ago
I’m a bit confused about the difference between OLAP and OLTP in this context. I think option E might be wrong since we need to avoid impacting performance.
upvoted 0 times
...
Carissa
4 months ago
I practiced a similar question where we had to connect Spark to Cosmos DB, and I feel like using cosmos.olap in an Apache Spark pool could be the right approach, which points to option A.
upvoted 0 times
...
Kara
4 months ago
I'm not entirely sure, but I think creating a private endpoint could help with security and performance, so option B might be correct too.
upvoted 0 times
...
Justine
5 months ago
I remember something about using Azure Synapse Link for real-time analytics, so maybe option D is one of the answers.
upvoted 0 times
...
Moira
5 months ago
Hmm, I'm not sure about this. There are a lot of moving parts here with Cosmos DB, Synapse, and machine learning. I'll need to really focus and make sure I understand the implications of each option before making a decision.
upvoted 0 times
...
Kendra
5 months ago
I feel pretty confident about this one. I think the best approach is to use Azure Synapse Link to create an analytical store, which will allow us to analyze the data without impacting the web apps. I'll select options B and D.
upvoted 0 times
...
Nadine
5 months ago
Okay, I think I've got a strategy here. The key is to find a way to analyze the data without affecting the web apps. I'm leaning towards options B and D, but I'll need to research them further.
upvoted 0 times
...
Stanford
5 months ago
I'm a bit confused by the wording here. Do we need to use both Azure Synapse and Cosmos DB? I'll have to double-check the requirements.
upvoted 0 times
...
Rhea
5 months ago
Hmm, this looks like a tricky one. I'll need to carefully read through the options and think about how each one might impact the web apps' performance.
upvoted 0 times
...
Christiane
5 months ago
I've got a strategy - I'll start by eliminating any queries that have obvious syntax errors or use invalid column names. Then I'll focus on the date comparisons and GROUP BY clauses to determine which ones will execute successfully.
upvoted 0 times
...
Silvana
5 months ago
I think recall is calculated as true positives divided by the sum of true positives and false negatives, but I'm not entirely sure about the values from the matrix.
upvoted 0 times
...
Hassie
10 months ago
Hey, at least they didn't ask us to use a Cosmos DB Gremlin API account. I hear that's where all the vampires hang out.
upvoted 0 times
...
Detra
10 months ago
Wait, we're not allowed to use the serverless SQL pool? Bummer, I was just about to whip up a sweet little view. Guess I'll have to stick with that Spark pool and cross my fingers.
upvoted 0 times
...
Ngoc
10 months ago
Ooh, I like the sound of that private endpoint connection. Keeps those web apps nice and cozy while I'm crunching numbers over here. And that Synapse Link? Sounds like a party!
upvoted 0 times
Elbert
9 months ago
B) Create a private endpoint connection to the account.
upvoted 0 times
...
Rebbecca
9 months ago
A) In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.
upvoted 0 times
...
...
Emiko
10 months ago
Haha, no way I'm using 'cosmos.oltp' as the data source. That's like trying to race a Formula 1 car on a dirt track. Gotta use the analytical side, baby!
upvoted 0 times
Jose
9 months ago
User 3: Let's go with enabling Azure Synapse Link and Analytical store on the container for the best results.
upvoted 0 times
...
Elouise
9 months ago
User 2: Totally agree, we should use 'cosmos.olap' for better performance.
upvoted 0 times
...
Olene
10 months ago
User 1: Yeah, 'cosmos.oltp' is definitely not the way to go for machine learning models.
upvoted 0 times
...
...
Chantell
10 months ago
Hmm, I think options B and D are the way to go. Gotta keep that data secure, you know? And enabling the Analytical store is key for that Spark data analysis.
upvoted 0 times
Gerardo
9 months ago
Using Apache Spark in Azure Synapse seems like a good choice for creating machine learning models.
upvoted 0 times
...
Gilberto
10 months ago
It's crucial to ensure the performance of the web apps is not affected while analyzing the data.
upvoted 0 times
...
Daron
10 months ago
Enabling Azure Synapse Link for the account and Analytical store is definitely important for data analysis.
upvoted 0 times
...
Patria
10 months ago
I agree, creating a private endpoint connection will help keep the data secure.
upvoted 0 times
...
...
Keva
11 months ago
We should also enable Azure Synapse Link for the account and Analytical store on the container for better data analysis.
upvoted 0 times
...
Cruz
11 months ago
I agree with Barrett. That will ensure the solution does not affect the performance of the web apps.
upvoted 0 times
...
Barrett
11 months ago
I think we should create a private endpoint connection to the account.
upvoted 0 times
...

Save Cancel