You administer all the deployments of Microsoft SQLServer 2012 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting
requirements can be off-loaded from the primary database to another server.
You also Need to be able to add indexes to the secondary database.
Which configuration should you use?
A.
• Two servers configured in different data centers
• SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
• One server configured as an Active Secondary
B.
• Two servers configured in the same data center
• SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode
• One server configured as an Active Secondary
C.
• Two servers configured in the same data center
• A primary server configured to perform log-shipping every 10 minutes
• A backup server configured as a warm standby
D.
• Two servers configured in different data centers
• SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode
E.
• Two servers configured on the same subnet
• SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
F.
• SQL Server that includes an application database configured to perform
transactional replication
G.
• SQL Server that includes an application database configured to perform snapshot
replication
H.
• Two servers configured in a Windows Failover Cluster in the same data center
• SQL Server configured as a clustered instance
Explanation:
I’m not answering as I dont have any idea (originalis F)
I think is correct F, because the requirement is “..up-to-the-minute reporting requirement..”
…. and “Need to be able to add indexes to the secondary database”
Very nice explanation here: https://dba.stackexchange.com/questions/101224/secondary-replica-indexing