Administering Microsoft SQL Server 2012/2014 Databases — Question 41

You have been hired as a Database Consultant by ABC.com to design a SQL Server 2012 database solution.
You are tasked with designing a scale-out and high-availability SQL Server 2012 Online
Transaction Processing (OLTP) database solution that will maintain copies of data across two server instances.
Your solution must provide scale-out of read operations by distributing the reads from clients across two SQL Server 2012 nodes. The data in both SQL Server nodes needs to be indexed.
What should you include in your solution?

Answer options

• A. You should include a primary database with scheduled log shipping to the secondary database configured.
• B. You should include two servers configured in an Active-Passive SQL Server 2012 Cluster.
• C. You should include a primary SQL Server 2012 database that uses transactional replication to replicate data to the secondary database.
• D. You should include two servers in an Asynchronous-Commit Availability Mode Availability Group.
• E. You should include two servers in a Synchronous-Commit Availability Mode Availability Group.

Correct answer: C

Explanation

The correct answer is C because transactional replication allows for the distribution of read operations across multiple servers while keeping the data synchronized. Option A is incorrect as log shipping does not provide real-time data access for reads. Option B is not suitable since an Active-Passive Cluster does not allow for read scaling across two nodes. Options D and E involve Availability Groups, which are more focused on high availability rather than read scaling in this context.