exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 17 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 17
[All DP-201 Questions]

You need to design a backup solution for the processed customer data.
What should you include in the design?

  • A. AzCopy
  • B. AdlCopy
  • C. Geo-Redundancy
  • D. Geo-Replication
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
Scenario: All data must be backed up in case disaster recovery is required.
Geo-redundant storage (GRS) is designed to provide at least 99.99999999999999% (16 9's) durability of objects over a given year by replicating your data to a secondary region that is hundreds of miles away from the primary region. If your storage account has GRS enabled, then your data is durable even in the case of a complete regional outage or a disaster in which the primary region isn't recoverable.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy-grs

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dcpavelescu
Highly Voted 4 years, 9 months ago
Answer C is correct. Assuming: - Inferred from case: processed customer data is stored in SQL DWS - Technical requirements: "All data must be backed up in case disaster recovery is required" SQL DWS has the following solutions for restore/disaster revovery: - snapshots (automatic, user defined) - cannot fulfill the need that all data is backed up RPO <= 8h - geo-backups - cannot fulfill the need that all data is backed up RPO <= 24h (https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore#:~:text=A%20geo%2Dbackup%20is%20created,points%20in%20your%20primary%20region.) - geo-redundant storage for disaster recovery - fulfill the need that all data is backed up (https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/)
upvoted 10 times
...
danseol
Highly Voted 5 years, 2 months ago
Replication is not a backup solution. Erroneous deletes will be replicated as well.
upvoted 8 times
groy
4 years, 7 months ago
you could have said, the given answer is correct - C. Geo-Redundancy and then posted your comment..... as the comment is confusing people..
upvoted 21 times
...
...
syu31svc
Most Recent 4 years, 5 months ago
C for correct https://docs.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy geo-redundancy for backup geo-replication for disaster recovery
upvoted 3 times
...
M0e
4 years, 6 months ago
Assuming the processed customer data is stored in Azure DW (following the previous discussions) and as per this document: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore, the given answer is correct. Although, the recent wording in Synapse Analytics is Geo-Backups.
upvoted 2 times
...
Sudipta3009
4 years, 10 months ago
-Geo-redundancy signifies a computer system operating at two or more geographical locations as a redundancy in case the primary system fails due to any reason. -Active geo-replication is designed as a business continuity solution that allows the application to perform quick disaster recovery of individual databases in case of a regional disaster or large scale outage. Both the concept sounds relatable to the context of the question which mentions "All data must be backed up in case disaster recovery is required" So anyone has the correct explanation to this and what would be the correct answer
upvoted 3 times
...
CNBOOST2
4 years, 11 months ago
so geo redundancy is the right answer?
upvoted 4 times
...
Leonido
5 years ago
In other words, Geo-Rep is for HA and Geo-Backup is for DR
upvoted 7 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago