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?
You wont be able to create restore point when the SQL pool is paused. The the correct answer is Result SQL Pool. See below from Microsoft documentation.
User-defined restore points can also be created through Azure portal.
Sign in to your Azure portal account.
Navigate to the dedicated SQL pool (formerly SQL DW) that you want to create a restore point for.
Select Overview from the left pane, select + New Restore Point. If the New Restore Point button isn't enabled, make sure that the dedicated SQL pool (formerly SQL DW) isn't paused.
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points
ou wont be able to create restore point when the SQL pool is paused. The the correct answer is Result SQL Pool. See below from Microsoft documentation.
Dedicated SQL pool should be in an active state for restore point creation.
https://learn.microsoft.com/en-us/troubleshoot/azure/synapse-analytics/dedicated-sql/dsql-maint-backup-restore-guidance?source=recommendations
Correct answer is C.
Not restore points are created when pool is paused. And there default retention is 7 days.
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore#automatic-restore-points
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 running.
This section is not available anymore. Please use the main Exam Page.DP-203 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
yogiazaad
Highly Voted 2 years, 4 months agoesaade
Highly Voted 2 years, 3 months agoHarteko
Most Recent 7 months agoBill_Walker
1 year, 4 months agoLucasmh
1 year, 5 months agomsb
1 year, 8 months agokkk5566
1 year, 9 months agoauwia
1 year, 11 months agoAst999
2 years, 3 months agoRV123
2 years, 5 months agodom271219
2 years, 9 months agokumarrahul1107
2 years, 9 months ago