Câu 2: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases
You administer a Microsoft SQL Server database. You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatic…
Nội dung câu hỏi
You administer a Microsoft SQL Server database. You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically. Which Transact-SQL statement should you use?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. ALTER AVAILABILITY GROUP haContosoDbs MODITY REPLICA ON Server01\Contoso01 WITH (AVAILABILITY _MODE=ASYNCHRONOUS_COMMIT, FAILOVER_MODE=AUTOMATIC)
- B. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON Server01\Contoso01 WITH (AVAILABILITY _MODE=ASYNCHRONOUS_COMMIT, FAILOVER_MODE=MANUAL)
- C. ALTER AVAILABILITY GROUP haContosoDbs MODITY REPLICA ON Server01\Contoso01 WITH (AVAILABILITY _MODE=SYNCHRONOUS_COMMIT, FAILOVER_MODE=AUTOMATIC) — đáp án hiện tại
- D. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON Server01\Contoso01 WITH (AVAILABILITY _MODE=SYNCHRONOUS_COMMIT, FAILOVER_MODE=MANUAL)
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.