You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused. You need to restore the current state of SQLPool1 to a new…

The correct answer is C. Resume SQLPool1. You cannot create user-defined restore points when the Azure Synapse Analytics dedicated SQL pool is currently paused. In order to create a user-defined restore point, the SQL pool must be https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data…

Submitted by ravi_2018· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused. You need to restore the current state of SQLPool1 to a new SQL pool. What should you do first?

Options

ACreate a workspace.
BCreate a user-defined restore point.
CResume SQLPool1.
DCreate a new SQL pool.

How the community answered

(65 responses)

A
11% (7)
B
6% (4)
C
82% (53)
D
2% (1)

Explanation

You cannot create user-defined restore points when the Azure Synapse Analytics dedicated SQL pool is currently paused. In order to create a user-defined restore point, the SQL pool must be https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-restore-points

Topics

#Azure Synapse restore#dedicated SQL pool#restore point#backup and recovery

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice