Exam DP-900 topic 1 question 142 discussion

Actual exam question from Microsoft's DP-900

Question #: 142
Topic #: 1

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

A. Scale down the data warehouse units (DWUs).
B. Pause the pool.
C. Create a user-defined restore point.
D. Delete the pool

Show Suggested Answer

Suggested Answer: B 🗳️

by bfan95 at April 25, 2022, 1:39 p.m.

Comments

Submit Cancel

JA2018

Highly Voted 2 years, 8 months ago

Selected Answer: B

"B" is the correct answer. https://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs Dedicated SQL pool You can control costs for a dedicated SQL pool by pausing the resource when it is not is use. For example, if you won't be using the database during the night and on weekends, you can pause it during those times, and resume it during the day. For more information, see Pause and resume compute in dedicated SQL pool via the Azure portal.

upvoted 12 times

...

bfan95

Highly Voted 3 years, 2 months ago

Pause the pool, answer: B

upvoted 8 times

...

AGTraining

Most Recent 1 year, 4 months ago

option B

upvoted 1 times

...