Administering a SQL Database Infrastructure — Question 77

You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA.
Currently, Server01l/HA is the primary replica.
You need to ensure that the following requirements are met:
✑ Backup operations occur on Server02/HA.
✑ If Server02/HA is unavailable, backup operations occur on Server03/HA.
✑ Backup operations do not occur on Server01/HA.
How should you configure HaContoso?

Answer options

• A. Set the backup preference of HaContoso to Prefer Secondary. Set the backup priority of Server02/HA to 20. Set the backup priority of Server03/HA to 10.
• B. Set the backup preference of HaContoso to Secondary only. Set the backup priority of Server02/HA to 20. Set the backup priority of Server03/HA to 10.
• C. Set the backup preference of HaContoso to Secondary only. Set the backup priority of Server02/HA to 10. Set the backup priority of Server03/HA to 20.
• D. set the exclude replica of Server01/HA to true. Set the backup priority of Server02/HA to 10. Set the backup priority of Server03/HA to 20.

Correct answer: B

Explanation

The correct answer is B because setting the backup preference to 'Secondary only' ensures that backups only occur on the secondary replicas. By giving Server02/HA a higher priority (20) than Server03/HA (10), it guarantees that Server02/HA is used first, and if it is unavailable, then Server03/HA will handle the backups. Options A and C incorrectly configure the priorities or preferences, and option D does not address the requirement of prioritizing Server02/HA over Server03/HA.