exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 7 question 2 discussion

Actual exam question from Microsoft's DP-200
Question #: 2
Topic #: 7
[All DP-200 Questions]

DRAG DROP -
You need to provision the polling data storage account.
How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE:
Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Account type: StorageV2 -
You must create new storage accounts as type StorageV2 (general-purpose V2) to take advantage of Data Lake Storage Gen2 features.
Scenario: Polling data is stored in one of the two locations:
✑ An on-premises Microsoft SQL Server 2019 database named PollingData
✑ Azure Data Lake Gen 2
Data in Data Lake is queried by using PolyBase

Replication type: RA-GRS -
Scenario: All services and processes must be resilient to a regional Azure outage.
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.
If you opt for GRS, you have two related options to choose from:
✑ GRS replicates your data to another data center in a secondary region, but that data is available to be read only if Microsoft initiates a failover from the primary to secondary region.
✑ Read-access geo-redundant storage (RA-GRS) is based on GRS. RA-GRS replicates your data to another data center in a secondary region, and also provides you with the option to read from the secondary region. With RA-GRS, you can read from the secondary region regardless of whether Microsoft initiates a failover from the primary to secondary region.
References:
https://docs.microsoft.com/bs-cyrl-ba/azure/storage/blobs/data-lake-storage-quickstart-create-account 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
STH
Highly Voted 5 years, 6 months ago
We do not have to read data from the secondary region : only GRS is needed (with smallest cost than RA-GRS)
upvoted 35 times
dfrp92
4 years, 11 months ago
It also states that the solution must be resilient. You cannot achieve achieve true resilience with only GRS. Applications will have downtime during the failover period. I believe RA-GRS is the correct answer.
upvoted 15 times
Avinash75
3 years, 11 months ago
The difference between GRS and RA GRS is fairly simple, GRS only allows to be read in the secondary zone in the even of a failover from the primary to secondary while RA GRS allows the option to read in the secondary whenever. Since cost has to be minimized we need only GRS and not RA-GRS , the requirement is to be Resilient at minimized cost .
upvoted 1 times
...
...
...
SAMBIT
Highly Voted 5 years, 3 months ago
RA-GRS is the correct answer. In case of failure you can read the data and minimize impact on the application. With GRS that won't be possible. Cost is not important in exams. Go with the best available assuming there is not constraint set in the question itself.
upvoted 16 times
SachinKumar2
5 years, 2 months ago
Its mentioned in question clearly that "The solution must minimize costs.". So, GRS should be the correct answer here.
upvoted 7 times
...
SheShanD
4 years, 11 months ago
In case of failure ..failover will happen anyway.
upvoted 3 times
...
...
Uday0809
Most Recent 4 years, 6 months ago
Replication Type= GRS
upvoted 3 times
...
lingjun
4 years, 6 months ago
Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. When you enable read access to the secondary region, your data is available to be read at all times, including in a situation where the primary region becomes unavailable.
upvoted 1 times
...
datachamp
4 years, 7 months ago
RA-GRS is the correct answer. It is mentioned in the question that "All services and processes must be resilient to a regional Azure outage." However, referred from the Microsoft docs: Geo-redundant storage carries a risk of data loss. Data is copied to the secondary region asynchronously, meaning there is a delay between when data written to the primary region is written to the secondary region. In the event of an outage, write operations to the primary endpoint that have not yet been copied to the secondary endpoint will be lost. This concludes that RA-GRS is the correct answer as per Microsoft docs "If an outage occurs in the primary endpoint, applications configured for read access to the secondary and designed for high availability can continue to read from the secondary endpoint. Microsoft recommends RA-GZRS for maximum availability and durability for your applications."
upvoted 2 times
dumpsm42
4 years, 6 months ago
hi, i dont think so because that's more expensive in terms of costs, the ideal is GRS. "...The storage must be available in the event of a regional disaster. The solution must minimize costs....." <= minimize : RA-GRS cost > GRS cost and GRD already permits failover to a secondary region so for me this is the right answer regards
upvoted 3 times
...
...
hart232
4 years, 8 months ago
"Microsoft recommends RA-GZRS for maximum availability and durability for your applications."
upvoted 2 times
...
LeandroAmore
4 years, 11 months ago
acording to the doc here (https://docs.microsoft.com/en-us/azure/storage/common/storage-disaster-recovery-guidance) GRS has a manual failover step. so the RA-GRS would be the correct answer Geo-redundant storage (GRS) or geo-zone-redundant storage (GZRS) copies your data asynchronously in two geographic regions that are at least hundreds of miles apart. If the primary region suffers an outage, then the secondary region serves as a redundant source for your data. You can initiate a failover to transform the secondary endpoint into the primary endpoint. Read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS) provides geo-redundant storage with the additional benefit of read access to the secondary endpoint. If an outage occurs in the primary endpoint, applications configured for read access to the secondary and designed for high availability can continue to read from the secondary endpoint. Microsoft recommends RA-GZRS for maximum availability and durability for your applications.
upvoted 3 times
akn1
4 years, 11 months ago
It says " applications configured for read access to the secondary and designed for high availability can continue to read from the secondary endpoint" ,however you cant write to the secondary endpoint still. To do that a failover has to be initiated( manual ?. Does it say anywhere that RA-GRS has automatic -failover ?
upvoted 1 times
...
...
Anamitra
5 years ago
Dear Sambit, I guess that i not correct. GRS supports automatic fail over. Also, there is no requirement mentioned in the question that without failover also, READ access required. So my guess is GRS is the right answer.
upvoted 5 times
...
samok
5 years, 3 months ago
RA-GRS is correct because it is the only that does migrations automatically
upvoted 6 times
...
Abbas
5 years, 5 months ago
I agree with you STH.
upvoted 1 times
tes
5 years, 5 months ago
you can agree with a comment or upvote
upvoted 6 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 ...