Microsoft Exam DP-900 Topic 11 Question 80 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 80
Topic #: 11

[All DP-900 Questions]

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

AScale down the data warehouse units (DWUs).

BPause the pool.

CCreate a user-defined restore point.

DDelete the pool

Show Suggested Answer

Suggested Answer: C

by Yan at May 01, 2024, 05:56 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

I disagree. I think scaling down the data warehouse units (DWUs) would be more cost-effective in the long run.

upvoted 0 times

...

3 days ago

I agree with Wilbert. Pausing the pool seems like the best option to save costs.

upvoted 0 times

...

7 days ago

I think we should pause the pool to minimize cost during idle times.

upvoted 0 times

...