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

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

Contribute your Thoughts:

Submit Cancel

Dick

16 hours ago

I'm torn between B and C. Pausing the pool is the easiest, but creating a user-defined restore point could be handy if you need to quickly restore the pool later. Hmm, decisions, decisions.

upvoted 0 times

...

Berry

13 days ago

I think scaling down the data warehouse units could also be a good option to consider. It might help in reducing costs while keeping the data intact.

upvoted 0 times

...

Josphine

14 days ago

I agree with Christoper. Pausing the pool seems like the best option to save money.

upvoted 0 times

...

B) Pause the pool - This is the most obvious choice. Pausing the pool will stop the compute resources and reduce the cost during idle times. The data will remain intact, and you can resume the pool when needed.

upvoted 0 times

24 days ago

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

upvoted 0 times

...

Microsoft Exam DP-900 Topic 11 Question 80 Discussion

Contribute your Thoughts:

Dick

Berry

Josphine

Mose

Yan

Willard

Christoper

Kendra

Merissa

Wilbert