Home » Microsoft » 70-473 v.2 » Which statement should you run?
HOTSPOT
Your company has a Microsoft Azure subscription that contains an AlwaysOn availability group named AG01. AG01 contains two nodes named DB01 and DB02 and a database named DATABASE1.
You plan to add additional nodes to AG01.
You need to minimize the administrative effort required to add the node. The solution must ensure that AG01 is configured to prevent data loss and can file over without manual intervention.
Which statement should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: Automatic
Box 2: Synchronous Commit
Synchronous-commit replicas support two settings-automatic or manual.
Incorrect Answers:
Asynchronous-commit replicas support only the manual failover mode.
Box 3: SEEDING_MODE
SEEDING_MODE = { AUTOMATIC | MANUAL } Specifies how the secondary replica is initially seeded.
AUTOMATIC: Enables direct seeding. This method seeds the secondary replica over the network. This method does not require you to backup and restore a copy of the primary database on the replica.
Reference: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups?view=sqlserver-2017