DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 204


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:

Exam DP-200 Question 204
Show Answer
Correct Answer:
Exam DP-200 Question 204

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

Discussion

10 comments
Sign in to comment
STH
Nov 23, 2019

We do not have to read data from the secondary region : only GRS is needed (with smallest cost than RA-GRS)

dfrp92
Jun 25, 2020

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.

Avinash75
Jul 11, 2021

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 .

Avinash75
Jul 11, 2021

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 .

SAMBIT
Feb 19, 2020

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.

SachinKumar2
Mar 10, 2020

Its mentioned in question clearly that "The solution must minimize costs.". So, GRS should be the correct answer here.

SheShanD
Jun 19, 2020

In case of failure ..failover will happen anyway.

samok
Mar 9, 2020

RA-GRS is correct because it is the only that does migrations automatically

Anamitra
May 15, 2020

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.

LeandroAmore
Jul 9, 2020

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.

akn1
Jul 11, 2020

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 ?

Uday0809
Nov 12, 2020

Replication Type= GRS

hart232
Sep 26, 2020

"Microsoft recommends RA-GZRS for maximum availability and durability for your applications."

datachamp
Nov 2, 2020

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."

dumpsm42
Dec 10, 2020

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

Abbas
Dec 13, 2019

I agree with you STH.

Anonymous
Dec 26, 2019

you can agree with a comment or upvote

lingjun
Nov 10, 2020

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.