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…

The correct answer is B. Pause the pool. 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…

Submitted by kev92· Mar 30, 2026Describe an analytics workload on Azure

Question

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?

Options

AScale down the data warehouse units (DWUs).
BPause the pool.
CCreate a user-defined restore point.
DDelete the pool

How the community answered

(24 responses)

A
17% (4)
B
75% (18)
C
4% (1)
D
4% (1)

Explanation

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. https://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs

Topics

#Azure Synapse Analytics#dedicated SQL pool#cost optimization#pause/resume

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice