Data Engineering on Microsoft Azure — Question 43

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?

Answer options

• A. Create a workspace.
• B. Create a user-defined restore point.
• C. Resume SQLPool1.
• D. Create a new SQL pool.

Correct answer: C

Explanation

The correct action is to resume SQLPool1, as this is necessary before any restoration can occur. The options to create a workspace, a user-defined restore point, or a new SQL pool cannot be executed until SQLPool1 is active again.