Exam AZ-120 topic 3 question 34 discussion

Actual exam question from Microsoft's AZ-120

Question #: 34
Topic #: 3

You have an SAP production landscape that uses SAP HANA databases on Azure.

You need to deploy a disaster recovery solution to the SAP HANA databases. The solution must meet the following requirements:

• Support failover between Azure regions.
• Minimize data loss in the event of a failover.

What should you deploy?

A. HANA system replication that uses asynchronous replication
B. Azure Site Recovery
C. Always On availability group
D. HANA system replication that uses synchronous replication

Show Suggested Answer

Suggested Answer: A 🗳️

by tmtrg000 at April 23, 2023, 11:17 a.m.

Comments

Submit Cancel

srishigupta

6 months, 2 weeks ago

Ideally it should be asynchronous replication for DR, but as question specifically says minimum data loss then it should be D.

upvoted 4 times

...

contactakashnath

6 months, 3 weeks ago

When setting up HSR for Disaster Recovery between two different regions we have to select async replication. The given answer is correct.

upvoted 1 times

...

tmtrg000

1 year, 1 month ago

Option D - HANA system replication that uses synchronous replication - is the best option for this scenario. Synchronous replication ensures that changes are written to both the primary and secondary HANA databases before the transactions are committed. This ensures that there is no data loss in the event of a failover, as all changes are fully replicated to the secondary database. However, synchronous replication can have a higher impact on performance than asynchronous replication. Azure Site Recovery is a disaster recovery solution that can be used to replicate and failover virtual machines, but it is not specifically designed for SAP HANA databases. Always On availability group is a SQL Server feature and is not applicable for SAP HANA databases.

upvoted 2 times

...