Microsoft Exam DP-203 Topic 4 Question 84 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 84
Topic #: 4

You have an Azure subscription that contains an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos D6 database account named Cosmos1 Costmos1 contains a container named container 1 and ws1 contains a serverless1 SQL pool.

you need to ensure that you can Query the data in container by using the serverless1 SQL pool.

Which three actions should you perform? Each correct answer presents part of the solution

NOTE: Each correct selection is worth one point.

AEnable Azure Synapse Link for Cosmos1

BDisable the analytical store for container1.

CIn ws1. create a linked service that references Cosmos1

DEnable the analytical store for container1

EDisable indexing for container1

Show Suggested Answer

Suggested Answer: A, C, D

by Layla at Mar 06, 2024, 12:00 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blair

5 months ago

No, we should actually enable the analytical store for container1 to optimize query performance.

upvoted 0 times

...

Elke

5 months ago

Should we disable the analytical store for container1 then?

upvoted 0 times

...

Xochitl

6 months ago

Yes, that's correct. It will help us connect to the database.

upvoted 0 times

...

Alline

6 months ago

We also need to create a linked service in ws1 that references Cosmos1, right?

upvoted 0 times

...

Rachael

6 months ago

Yes, that makes sense. It will allow us to query the data in container1.

upvoted 0 times

...

Norah

6 months ago

I think we should enable Azure Synapse Link for Cosmos1

upvoted 0 times

...

Hildegarde

7 months ago

Absolutely, those two options seem to be the core of the solution. As for the third action, I think option C is the way to go - creating a linked service in ws1 that references Cosmos1 will allow the Synapse Analytics workspace to connect to the Cosmos DB account.

upvoted 0 times

...

Pearly

7 months ago

Sounds like a solid plan. Let's go with those three options and see if we can get some points on the board!

upvoted 0 times

...

Verda

7 months ago

Haha, good analogy there! Alright, let's recap the three actions we should perform: enable Azure Synapse Link for Cosmos1, enable the analytical store for container1, and create a linked service in ws1 that references Cosmos1.

upvoted 0 times

Providencia

6 months ago

Don't forget to create a linked service in ws1 that references Cosmos1.

upvoted 0 times

...

Brandee

6 months ago

And we also need to enable the analytical store for container1.

upvoted 0 times

...

Daniel

6 months ago

Definitely! We need to enable Azure Synapse Link for Cosmos1.

upvoted 0 times

...

Nichelle

7 months ago

Yeah, those options seem counterintuitive. I mean, who would want to disable the very things that enable the data to be queried effectively? It's like trying to bake a cake without any eggs or flour.

upvoted 0 times

...