nerdexam
Microsoft

70-465 · Question #104

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. To offload read/reporting workloads to an Always On Availability Groups secondary replica, you must configure the secondary's Readable Secondary property to allow read-intent connections. This directs ApplicationIntent=ReadOnly connection requests to the secondary replica.

Submitted by tarun92· Mar 5, 2026Design and implement database solutions for SQL Server

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

(31 responses)
  • A
    10% (3)
  • B
    81% (25)
  • C
    6% (2)
  • D
    3% (1)

Why each option

To offload read/reporting workloads to an Always On Availability Groups secondary replica, you must configure the secondary's Readable Secondary property to allow read-intent connections. This directs ApplicationIntent=ReadOnly connection requests to the secondary replica.

ASet the Availability Mode property of HA/Server02 to Asynchronous commit.

Setting the Availability Mode of HA/Server02 to Asynchronous commit only changes how transaction log records are synchronized between replicas, and does not by itself enable or configure read access on the secondary replica.

BSet the Readable Secondary property of HA/Server02 to Read-intent only.Correct

Setting the Readable Secondary property of HA/Server02 to 'Read-intent only' enables the secondary replica to accept read-only connections that specify ApplicationIntent=ReadOnly in their connection string. This allows reporting workloads to be redirected to HA/Server02 while HA/Server01 remains the primary, effectively offloading the read/reporting workload without impacting the primary replica's resources.

CSet the Connections in Primary Role property of HA/Server01 to Allow read/write connections.

Setting the Connections in Primary Role property of HA/Server01 to 'Allow read/write connections' configures connection behavior on the primary replica itself, not the secondary, so it does nothing to offload reporting workloads to HA/Server02.

DSet the Availability Mode property of HA/Server01 to Asynchronous commit.

Setting the Availability Mode of HA/Server01 to Asynchronous commit affects data synchronization durability between replicas but does not enable read access on the secondary replica or redirect any reporting workload to HA/Server02.

Concept tested: Configuring readable secondary replicas in Always On Availability Groups

Source: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-access-on-an-availability-replica-sql-server

Topics

#AlwaysOn Availability Groups#Readable secondary#Workload offloading

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice