
Answer-first summary for fast verification
Answer: Resume SQLPool1.
## Detailed Explanation To restore the current state of a paused Azure Synapse Analytics dedicated SQL pool (SQLPool1) to a new SQL pool, the first required action is to **resume SQLPool1**. ### Why Resume SQLPool1 First? **Technical Requirement:** - Azure Synapse Analytics dedicated SQL pools must be in an **active (running) state** to perform most administrative operations, including creating user-defined restore points - When a SQL pool is paused, it's essentially in a stopped state where compute resources are deallocated, making it impossible to create new restore points or perform backup-related operations **Restore Process Flow:** 1. **Resume SQLPool1** - Bring the pool online to an active state 2. **Create a user-defined restore point** - Capture the current state while the pool is running 3. **Restore to new SQL pool** - Use the created restore point to provision a new SQL pool with the captured state ### Analysis of Other Options: **A: Create a workspace** - ❌ **Incorrect** - Creating a new workspace is unrelated to restoring an existing SQL pool - Workspace creation is a separate administrative task that doesn't help with restoring a paused SQL pool **B: Create a user-defined restore point** - ❌ **Incorrect** - This operation **cannot be performed** while the SQL pool is paused - Azure prevents restore point creation on paused pools due to technical limitations with accessing the data and metadata **D: Create a new SQL pool** - ❌ **Incorrect** - Creating a new SQL pool without first capturing the current state of SQLPool1 would result in an empty pool - This doesn't achieve the objective of restoring SQLPool1's current state to a new pool ### Best Practice Considerations: - Always ensure SQL pools are in an active state before attempting backup or restore operations - User-defined restore points provide flexibility for point-in-time recovery scenarios - The resume operation is necessary to make the SQL pool's data and metadata accessible for restore point creation This approach follows Azure Synapse Analytics best practices and ensures the restore operation can be completed successfully.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have an Azure subscription containing a dedicated SQL pool in Azure Synapse Analytics named SQLPool1, which is currently in a paused state. You need to restore the current state of SQLPool1 to a new SQL pool. What is the first action you must perform?
A
Create a workspace.
B
Create a user-defined restore point.
C
Resume SQLPool1.
D
Create a new SQL pool.
No comments yet.