You need to recommend a disaster recovery solution for the back-end tier of the payment processing system. What should you include in the recommendation?
Suggested Answer:B🗳️
Scenario: ✑ The back-end data store is implemented as a Microsoft SQL Server 2014 database. ✑ If a data center fails, ensure that the payment processing system remains available without any administrative intervention. Note: Auto-failover groups is a SQL Database feature that allows you to manage replication and failover of a group of databases on a SQL Database server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale. Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group
The question is targeting thie requirement:
If a data center fails, ensure that the payment processing system remains available without any administrative intervention. The middle-tier and the web front end must continue to operate without any additional configurations.
Azure Site Recovery
It's used for server recovery and has time outage
Always On Failover Cluster Instances
this is part of SQL server Always On, not suitable for Azure SQL database or Azure SQl Managed Instance
geo-redundant database
I guess this means Active geo-replication faeture. This needs manual intervention to execute failover.
Correct Answer: Auto-failover Group
It allows you to manage the replication and failover of a group of databases to another region. Also it allows you to automatically recover multiple related databases using a user-defined policy
This section is not available anymore. Please use the main Exam Page.AZ-304 Exam Questions
Log in to ExamTopics
Sign in:
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.
leo_az300
Highly Voted 3 years, 8 months agordemontis
3 years, 6 months agonkv
Highly Voted 3 years, 8 months ago[Removed]
Most Recent 3 years, 5 months agosyu31svc
3 years, 8 months agoExamerr
3 years, 8 months ago