Administering a SQL Database Infrastructure — Question 164

You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica.
You have multiple queries that read data and produce reports from the database.
You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica.
What should you do?

Answer options

• A. Set the Availability Mode property of HA/Server02 to Asynchronous commit.
• B. Set the Readable Secondary property of HA/Server02 to Read-intent only.
• C. Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
• D. Set the Availability Mode property of HA/Server01 to Asynchronous commit.

Correct answer: B

Explanation

The correct answer is B because setting the Readable Secondary property of HA/Server02 to Read-intent only allows read-only queries to be directed to the secondary replica, offloading the reporting workload. Option A does not specifically enable read access for reporting on the secondary. Option C allows read/write connections on the primary but does not help with offloading to the secondary. Option D changes the primary's availability mode but does not affect the secondary's ability to handle read queries.