exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 5 discussion

Actual exam question from Microsoft's DP-300
Question #: 5
Topic #: 6
[All DP-300 Questions]

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?

  • A. locally-redundant storage (LRS)
  • B. read-access geo-redundant storage (RA-GRS)
  • C. zone-redundant storage (ZRS)
  • D. geo-redundant storage (GRS)
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Geo-redundant storage (GRS) is cheaper compared to read-access geo-redundant storage (RA-GRS).
Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. Data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region.
Incorrect Answers:
A: Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requiring high availability.
B: RA-GRS is more expensive than GRS.
Note: 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 if the primary region becomes unavailable. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
C: Zone-redundant storage (ZRS) copies your data synchronously across three Azure availability zones in the primary region.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

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
Luke97
Highly Voted 4 years, 6 months ago
According to Microsoft, "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. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS)." So, if Primary Region is unavailable and MS did not failover, then you can only restore Backup on secondary region if it is RA-GRS.
upvoted 12 times
Sr18
11 months, 2 weeks ago
Key here is minimizing the cost so GRS serves the purpose. Here they are not talking about always Read its all about having a backup ready and cheaper.
upvoted 1 times
...
ondemand
4 years, 4 months ago
so, the answer should be D, GRS?
upvoted 1 times
U_C
4 years, 1 month ago
Assuming the primary region is not available and both MS and yourself can NOT initiates a failover, that means your data on secondary region is not readable if you use GRS. But RA-GRS is always readable. So the answer is B, RA-GRS.
upvoted 2 times
pr054
3 years, 10 months ago
If this was true GRS would be almost useless.
upvoted 2 times
...
...
...
bnc
4 years, 4 months ago
You can do the failover yourself on a GRS account, so technically GRS minimizes costs. That said, if you have a solution where all this DR is required, you'd almost certainly want RA-GRS for testing/verification. The cost difference is minimal (yes, the costs add up if you have tens of TBs of backups, but would represent only a very tiny percentage of the costs needed to run an app/db of this size). So again technically GRS but realistically you would select RA-GRS.
upvoted 4 times
...
...
U_C
Highly Voted 4 years, 2 months ago
The difference between GRS and RA-GRS: GRS - After failover, the read-only is available. If no failover, it can not be readable. RA-RGS - is always enable and read-only. If GRS is cheaper, D is the right answer.
upvoted 8 times
jeffangel28
4 years ago
That's correct: "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. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS)." Answer would be d since GRS is cheaper than RA-GRS
upvoted 2 times
...
...
voodoo_sh
Most Recent 4 months, 2 weeks ago
Selected Answer: D
Since I can't bring offline region in Azure, so I can't test below. But: D: Yes, it is possible to initiate a failover to the secondary region (West US 3) for your geo-redundant storage (GRS) account, even while the primary region (West US 2) is down. This process is known as a customer-managed failover. Here are the steps to initiate a failover: 1. Navigate to your storage account in the Azure portal. 2. Select "Redundancy" from the Data management section. 3. Initiate the failover by following the prompts. Once the failover is complete, the secondary region (West US 3) will become the new primary region, and your data will be accessible there. Since GRS is cheaper than RAGRS, and according to above you just need to perform a customer initiated failover when primary region is down, I think answer is D: GRS
upvoted 1 times
...
bingomutant
8 months ago
chat - While RA-GRS offers more features with the ability to read backups in the secondary region before failover, the question's emphasis on minimizing costs and ensuring that backups can be restored during an outage points to GRS as the best fit. So I prefer D in this context
upvoted 1 times
...
Dalamain
1 year, 1 month ago
I've researched it myself and read the comments ... I'm sticking with B (RA-GRS) - I think the addition of "minimize cost" is a trick especially since this scenario relates to Azure VMs. If the scenario mentioned "failover" I'd be inclined to pick D (GRS).
upvoted 1 times
...
kannan94
1 year, 3 months ago
ChatGPT - C.ZRS
upvoted 1 times
...
TheMCT
2 years, 2 months ago
Selected Answer: D
Correct answer is D: It's cheaper. Both GRS and RA-GRS replicate data to a secondary region, providing redundancy in the event of a regional outage. RA-GRS additionally allows read access to the secondary region, which can be useful for disaster recovery scenarios. However, RA-GRS accounts are more expensive than GRS accounts.
upvoted 1 times
...
KingChuang
2 years, 3 months ago
Selected Answer: D
I think the answer is D. Because D cheaper than B.
upvoted 1 times
...
reachmymind
3 years, 2 months ago
Selected Answer: B
B. read-access geo-redundant storage (RA-GRS) The ask is to "building a database backup solution" so we need to be able to test the solution https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy If your storage account is configured for read access to the secondary region, then you can design your applications to seamlessly shift to reading data from the secondary region if the primary region becomes unavailable for any reason. The secondary region is available for read access after you enable RA-GRS or RA-GZRS, so that you can test your application in advance to make sure that it will properly read from the secondary in the event of an outage. For more information about how to design your applications to take advantage of geo-redundancy
upvoted 2 times
Dalamain
1 year, 1 month ago
... and what else is being asked?? "minimize costs"
upvoted 1 times
...
...
aakben
3 years, 8 months ago
Azure Storage supports account failover for geo-redundant storage accounts. With account failover, you can initiate the failover process for your storage account if the primary endpoint becomes unavailable. The failover updates the secondary endpoint to become the primary endpoint for your storage account. Once the failover is complete, clients can begin writing to the new primary endpoint. 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. https://docs.microsoft.com/en-us/azure/storage/common/storage-disaster-recovery-guidance
upvoted 2 times
...
learnazureportal
3 years, 10 months ago
Answer is D. b/c, the use case says; "due to Azure regional outage, you need to be able to restore the database backups."
upvoted 2 times
...
Raffer
4 years, 2 months ago
Answer is correct: B. https://medium.com/@aslanim/azure-accessing-your-sql-server-backups-in-your-ra-grs-account-17e0c7457146
upvoted 4 times
...
Raffer
4 years, 2 months ago
D is correct. "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. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS)." https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#read-access-to-data-in-the-secondary-region In the question's scenario, a failover to another region *is* required, so GRS is suitable. GRS is also a bit less expensive than RA-GRS.
upvoted 1 times
...
Jas_dandiwal
4 years, 3 months ago
how come RA-GRS can be cheaper as this is a addon to provide access to data in secondary region even there is no outage in primary region. GRS should be cheaper as it replicates data and only accessible once primary region has an outage. Read the below from MS. With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS) In extreme circumstances where a region is lost due to a significant disaster, Microsoft may initiate a regional failover. In this case, no action on your part is required. Until the Microsoft-managed failover has completed, you won't have write access to your storage account. Your applications can read from the secondary region if your storage account is configured for RA-GRS or RA-GZRS.
upvoted 2 times
...
mzahyt
4 years, 4 months ago
D is correct as it is the cheaper option. Key word "minimize" costs.
upvoted 4 times
...
JakubWBialystok
4 years, 4 months ago
Only D. geo-redundant https://docs.microsoft.com/en-us/azure/architecture/resiliency/recovery-loss-azure-region#recovery-by-using-geo-redundant-storage-of-blob-table-queue-and-vm-disk-storage
upvoted 1 times
...
JohnCrawford
4 years, 5 months ago
Disregard my comment about ZRS being the correct solution. As they note in the answer the copies made in the different zones are all in the same REGION. Here we are presented with a regional outage so ZRS will not suffice.
upvoted 2 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 ...