DP-203 · Question #382
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool. You need to create a copy of the data warehouse and make the copy available for 28 days. The solution must minimize…
The correct answer is Create a new user-defined restore point.; Restore the copy from the new user-defined restore point to a new data warehouse.; Pause the restored data warehouse. The correct sequence is: (1) Create a new user-defined restore point to capture the exact current state of the data warehouse, (2) Restore the copy from the new user-defined restore point to a new data warehouse to create the copy, and (3) Pause the restored data warehouse to…
Question
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool. You need to create a copy of the data warehouse and make the copy available for 28 days. The solution must minimize costs. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:
Exhibit
Answer Area
Drag items
Correct arrangement
- Create a new user-defined restore point.
- Restore the copy from the new user-defined restore point to a new data warehouse.
- Pause the restored data warehouse.
Explanation
The correct sequence is: (1) Create a new user-defined restore point to capture the exact current state of the data warehouse, (2) Restore the copy from the new user-defined restore point to a new data warehouse to create the copy, and (3) Pause the restored data warehouse to minimize costs while keeping it available for 28 days. User-defined restore points are preferred over automatic restore points because they capture a precise snapshot at a known moment, and pausing the restored warehouse stops compute billing while retaining all data for the required retention period.
Topics
Community Discussion
No community discussion yet for this question.