Home » Microsoft » DP-201 v.2 » Which three actions should you include in the design?
You store data in an Azure SQL data warehouse.
You need to design a solution to ensure that the data warehouse and the most current data is available within one hour of a datacenter failure.
Which three actions should you include in the design? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Each day, restore the data warehouse from a geo-redundant backup to an available Azure region.
B. If a failure occurs, update the connection strings to point to the recovered data warehouse.
C. If a failure occurs, modify the Azure Firewall rules of the data warehouse.
D. Each day, create Azure Firewall rules that allow access to the restored data warehouse.
E. Each day, restore the data warehouse from a user-defined restore point to an available Azure region.
Correct Answer: BDE
Explanation/Reference:
Explanation:
E: You can create a user-defined restore point and restore from the newly created restore point to a new data warehouse in a different region.
Note: A data warehouse snapshot creates a restore point you can leverage to recover or copy your data warehouse to a previous state.
A data warehouse restore is a new data warehouse that is created from a restore point of an existing or deleted data warehouse. On average within the same region, restore rates typically take around 20 minutes.
Incorrect Answers:
A: Synapse Analytics performs a geo-backup once per day to a paired data center. The RPO for a geo-restore is 24 hours. You can restore the geo-backup to a server in any other region where Synapse Analytics is supported. A geo-backup ensures you can restore data warehouse in case you cannot access the restore points in your primary region.
Reference:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/backup-and-restore