Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 3 question 29 discussion

Actual exam question from Microsoft's DP-201

Question #: 29
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: BDE 🗳️
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

by Tombarc at April 25, 2020, 9:37 a.m.

Comments

Submit Cancel

azurearch

Highly Voted 5 years, 1 month ago

It can be BCE instead of BDE Why to create firewall rule each day if we have one hour time to restore after failure

upvoted 34 times

Needium

4 years, 3 months ago

Actually C and D are a bit confusing to me. probably they are badly worded or it is just me. i would actually be looking out for an option like D. If a failure occurs, create Azure Firewall rules that allow access to the restored data warehouse. Why should I always create a firewall rule to open up the restored database pre-emptively? I believe it is safer to only create the firewall in the event of failures. Otherwise, an option C that explicitly qualifies the datawarehouse as restored would still have sounded more correct to me than the two options available in the question C. If a failure occurs, modify the Azure Firewall rules of the restored data warehouse.

upvoted 2 times

...

MG23

5 years, 1 month ago

C is a trick question to cause confusion, why would you update firewall rules on the existing data warehouse after it fails, existing being implied since they didn't mention restored. It's D because you're updating the restored database.

upvoted 15 times

...

proca

Highly Voted 4 years, 11 months ago

In my opinion the correct answer is B,D,E. Update connection strings -> "Because your recovered database resides in a different server, you need to update your application’s connection string to point to that server." Configure firewall rules -> You need to make sure that the firewall rules configured on server and on the database match those that were configured on the primary server and primary database. https://docs.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance?toc=/azure/synapse-analytics/sql-data-warehouse/toc.json&bc=/azure/synapse-analytics/sql-data-warehouse/breadcrumb/toc.json#configure-your-database-after-recovery

upvoted 11 times

syu31svc

4 years, 6 months ago

I agree with BDE as the answer based on the link you shared

upvoted 2 times

...

ebenajay

Most Recent 4 years, 5 months ago

Answer given is correct.

upvoted 2 times

...

ssgexam

4 years, 7 months ago

Shouldn't it be A, B & D?

upvoted 4 times

...

M0e

4 years, 8 months ago

Does ADW requires DAILY manual steps to provide 1 hour of RTO?? Realy??

upvoted 3 times

...

chanbull

4 years, 9 months ago

what all the suggested answers are all manual operations?? And why user defined restore point is what the most current data we want to restore??

upvoted 2 times

...

runningman

5 years, 1 month ago

but why suggest E if you say that a user defined rollback point is hard to establish accurately? I think A, then D in case there is an issue, then B to direct to working region.

upvoted 1 times

...

Tombarc

5 years, 2 months ago

In my opinion the correct answer is A,D,E. Azure synapse takes a snapshot roughly every 4 hours and 1 geo-snapshot every day to a paired region . The question talks about datacenter failure, so unless you can predict when the failure will occur to take a user-defined restore point, you should rely on the automated geo-snapshot.

upvoted 6 times

...