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, 6 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 ago

Pause the pool, answer: B

upvoted 8 times

...

Bin_Hashim

Most Recent 4 months, 4 weeks ago

Selected Answer: B

The correct answer is: B. Pause the pool Explanation: Pausing a dedicated SQL pool in Azure Synapse Analytics halts all compute activity while retaining the data in storage. During this time, you are not charged for compute resources, only for storage costs. This makes it the most cost-effective solution for periods of inactivity, such as during idle hours.

upvoted 1 times

...

AGTraining

1 year, 1 month ago

option B