Which three actions should you include in the design?

You store data in a data warehouse in Azure Synapse Analytics.

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.

View Answer

Answer: BDE

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: SQL Data Warehouse 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 SQL Data Warehouse 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