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

1 years ago

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

upvoted 0 times

...

Elke

1 years ago

Should we disable the analytical store for container1 then?

upvoted 0 times

...

Xochitl

1 years ago

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

upvoted 0 times

...

Alline

1 years ago

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

upvoted 0 times

...

Rachael

1 years ago

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

upvoted 0 times

...

Norah

1 years ago

I think we should enable Azure Synapse Link for Cosmos1

upvoted 0 times

...

Hildegarde

1 years 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

1 years 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

1 years 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

1 years ago

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

upvoted 0 times

...

Brandee

1 years ago

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

upvoted 0 times

...

Daniel

1 years ago

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

upvoted 0 times

...

Nichelle

1 years 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

...