Administering a SQL Database Infrastructure — Question 58

You are a database administrator for a Microsoft SQL Server 2016 instance.
You need to ensure that data can be replicated from a production server to two reporting servers in real time.
You also need to ensure that data on the reporting server is always accessible.
Which solution should you use?

Answer options

• A. Availability Groups
• B. Extended Events
• C. Snapshot Replication
• D. Policy Based Management

Correct answer: A

Explanation

The correct answer is A, Availability Groups, as they allow for real-time data replication and ensure high availability for reporting servers. The other options, such as Extended Events and Policy Based Management, do not provide data replication capabilities, while Snapshot Replication does not meet the real-time requirement.