Ensurepass
Vendor: Microsoft
Exam Code: 70-458
Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server
2012, Part 2 Exam

Latest Microsoft EnsurePass 70-458 Dumps PDF

QUESTION 1
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?

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.