Microsoft
70-457 · Question #145
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 correct answer is B. Set the Readable Secondary property of HA/Server02 to Read-intent only. See the full explanation below for the reasoning.
Question
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?
Options
- ASet the Availability Mode property of HA/Server02 to Asynchronous commit.
- BSet the Readable Secondary property of HA/Server02 to Read-intent only.
- CSet the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
- DSet the Availability Mode property of HA/Server01 to Asynchronous commit.
How the community answered
(22 responses)- A5% (1)
- B77% (17)
- C5% (1)
- D14% (3)
Community Discussion
No community discussion yet for this question.