exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 1 discussion

Actual exam question from Microsoft's AZ-305
Question #: 1
Topic #: 3
[All AZ-305 Questions]

You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process.
You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements:
✑ Provide the ability to recover in the event of a regional outage.
✑ Support a recovery time objective (RTO) of 15 minutes.
✑ Support a recovery point objective (RPO) of 24 hours.
✑ Support automated recovery.
✑ Minimize costs.
What should you include in the recommendation?

  • A. Azure virtual machine availability sets
  • B. Azure Disk Backup
  • C. an Always On availability group
  • D. Azure Site Recovery
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
[Removed]
Highly Voted 2 years, 11 months ago
Selected Answer: D
D is correct. Automatic Site Recovery needed.
upvoted 23 times
...
Gowind
Highly Voted 2 years, 3 months ago
Selected Answer: C
Answer is C Automated failover is needed. Azure site recovery does not support it https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-faq Is failover automatic? Failover isn't automatic. You initiate failovers with single click in the portal, or you can use Site Recovery PowerShell to trigger a failover. Failing back is a simple action in the Site Recovery portal.
upvoted 8 times
Vad133
1 year, 11 months ago
The requirements state "Support automated recovery", not "Automatic failover" thus we can automate the recovery process by a script and fulfil the requirement with low cost.
upvoted 8 times
GarryK
1 year, 10 months ago
You are right. Just checked the learning document, there is a whole section about Automating the recovery using Azure Automation Runbooks.
upvoted 1 times
...
...
maku067
1 year, 11 months ago
I think the same C. (Synchronous-commit mode with automatic failover) https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups?view=sql-server-ver16
upvoted 1 times
...
GarryK
1 year, 10 months ago
Hi (a.k.a Gowind) correcting me, Answer is D. The requirement is to support an automated recovery. We can automate the recovery with Azure Automation: https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-runbook-automation https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-create-recovery-plans Runbooks in recovery plans You add an Azure Automation account and runbooks to a recovery plan. The runbook is invoked when the recovery plan runs.
upvoted 5 times
...
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
Selected Answer: D
D is correct
upvoted 1 times
...
josola
2 months, 4 weeks ago
The answer is correct, but the question is kind of pointless. Unless you deal in a daily basis with SQL failover configuration, you won't know this answer right away. In real life, you will simply google and research what the best approach will be. In other words, this type of questions doesn't check if you really know the subject.
upvoted 2 times
...
Len83
3 months, 4 weeks ago
This question appeared in the exam, August 2024, I gave this same answer listed here. I scored 870
upvoted 1 times
...
Lazylinux
7 months, 1 week ago
Selected Answer: D
Given answer D is correct Azure Site Recovery provides BCDR features for your applications in Azure, on-premises, and in other cloud providers. The service offers plans to help automate your disaster recovery. You can define how your virtual machines are failed over, and the order in which they're restarted after successful failover. Things to consider when using Site Recovery Azure Site Recovery provides a simple BCDR solution with management support from the Azure portal. Set up and manage replication, fail over, and failback for your virtual machines from a single location. Set up disaster recovery of your Azure virtual machines, and fail over from a primary region to a secondary region. Automate your BCDR tasks and further reduce your recovery time objective. You can use Azure Site Recovery to set up automatic periodic test failovers, and monitor the overall effectiveness of the recovery process.
upvoted 1 times
...
thamaster
1 year ago
Selected Answer: D
question is about Recovery not HA, not restore
upvoted 3 times
...
marcellov
1 year, 2 months ago
Selected Answer: D
Replication with Azure Site Recovery. RTO is typically less than 15 minutes. RPO: One hour for application consistency and five minutes for crash consistency. https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-sql
upvoted 3 times
...
Elecktrus
1 year, 2 months ago
Selected Answer: D
Site Recovey because An Always On availability group is a high-availability and disaster recovery solution that provides automatic failover to a secondary replica in the same or a different data center. It can meet the RTO and RPO requirements, but it requires more resources and higher costs compared to the option of Azure Site Recovery
upvoted 2 times
...
VijayMS
1 year, 6 months ago
Always-On supports both Sync & Async replication and "C" should the be correct anwer
upvoted 1 times
...
sw1000
1 year, 6 months ago
Selected Answer: D
The only solutions making sense in this context are C and D: As we are talking about an SQL DB on an Azure VM (IaaS), there are NO cross-regional disaster recovery capabilities. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql#deployment-options:~:text=All-,DR%20with%20multiple%20regions,Yes,-Multisubnet%20support As we need to cover the scenario for a regional outage (which means all 3 data centers of an Azure region), the only option available to achieve this is Azure Site Recovery (with the help of runbooks if you must)
upvoted 1 times
sw1000
1 year, 6 months ago
D is the correct answer
upvoted 1 times
...
...
lvz
1 year, 6 months ago
Very interesting insite why it cant be azure backup? I was wondering because RPO of 24 hrs is supported by azure backup, however after some re-searched realized that RTO of 15 mins will not be supported by Azure Backup, so my second option was automatically Azure Site Recovery.
upvoted 1 times
...
NotMeAnyWay
1 year, 8 months ago
Selected Answer: D
D. Azure Site Recovery Azure Site Recovery is a disaster recovery service that allows you to protect your Azure virtual machines by orchestrating replication, failover, and recovery. It helps you meet the RTO and RPO requirements, automates recovery, and provides protection against regional outages. While it may not be the lowest cost solution, it meets all the other requirements, including automated recovery and support for the specified RTO and RPO.
upvoted 4 times
...
zellck
1 year, 9 months ago
Selected Answer: D
D is the answer. https://learn.microsoft.com/en-us/azure/site-recovery/azure-to-azure-enable-global-disaster-recovery#disaster-recovery-for-global-azure-regions Azure Site Recovery now supports global disaster recovery. You can now replicate and fail over your applications from any Azure region, across continents.
upvoted 3 times
...
abxc
1 year, 9 months ago
Selected Answer: D
https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#combining-bcdr-technologies-with-site-recovery. Check last option in the table
upvoted 2 times
...
totalz
1 year, 9 months ago
If I look at RPO, it's D. But I wouldn't call using the SDK for automation = support automated recovery. And if comparing the workload for cross regions, then the ans is def. D!!
upvoted 1 times
totalz
1 year, 9 months ago
However, with the super speedy azure, RTO of 15 minutes could be "fatal"!
upvoted 1 times
...
...
Putra19
1 year, 9 months ago
D because regional outage
upvoted 1 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 ...