MENU
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.
Suggested Answer: A
Get Premium DP-420 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
LO
Lorean
11 months ago
C could work, but I prefer D for better performance.
PA
Patrick
11 months ago
Wait, can we really use OPENROWSET with CosmosDB? Sounds risky!
AF
Afton
11 months ago
I think B is unnecessary, private endpoints aren't needed here.
SH
Shawna
12 months ago
A seems right too, using cosmos.olap is smart.
LU
Luther
12 months ago
Definitely go with D for enabling Synapse Link!
BA
Barney
1 year 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.
CA
Carissa
1 year 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.
KA
Kara
1 year 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.
JU
Justine
1 year ago
I remember something about using Azure Synapse Link for real-time analytics, so maybe option D is one of the answers.
MO
Moira
1 year 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.
KE
Kendra
1 year 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.
NA
Nadine
1 year 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.
ST
Stanford
1 year 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.
RH
Rhea
1 year 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.
CH
Christiane
1 year 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.
SI
Silvana
1 year 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.
HA
Hassie
1 year 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.
DE
Detra
1 year 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.
NG
Ngoc
1 year 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!
EL
Elbert
1 year ago
B) Create a private endpoint connection to the account.
RE
Rebbecca
1 year ago
A) In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.
EM
Emiko
2 years 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!
JO
Jose
1 year ago
User 3: Let's go with enabling Azure Synapse Link and Analytical store on the container for the best results.
EL
Elouise
1 year ago
User 2: Totally agree, we should use 'cosmos.olap' for better performance.
OL
Olene
1 year ago
User 1: Yeah, 'cosmos.oltp' is definitely not the way to go for machine learning models.
CH
Chantell
2 years 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.
GE
Gerardo
1 year ago
Using Apache Spark in Azure Synapse seems like a good choice for creating machine learning models.
GI
Gilberto
1 year ago
It's crucial to ensure the performance of the web apps is not affected while analyzing the data.
DA
Daron
1 year ago
Enabling Azure Synapse Link for the account and Analytical store is definitely important for data analysis.
PA
Patria
2 years ago
I agree, creating a private endpoint connection will help keep the data secure.
KE
Keva
2 years ago
We should also enable Azure Synapse Link for the account and Analytical store on the container for better data analysis.
CR
Cruz
2 years ago
I agree with Barrett. That will ensure the solution does not affect the performance of the web apps.
BA
Barrett
2 years ago
I think we should create a private endpoint connection to the account.