You administer all the deployments of Microsoft SQL Server 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
Ans. should be F.
?
The time to read or go to the subject material or web sites we have linked to beneath.
that would be the finish of this report. Right here youll obtain some web-sites that we feel youll value, just click the hyperlinks over
we prefer to honor a lot of other online internet sites around the web, even though they arent linked to us, by linking to them. Under are some webpages really worth checking out
we came across a cool web page that you simply could possibly delight in. Take a search when you want
the time to read or visit the material or web pages we’ve linked to beneath the
Sites of interest we have a link to
The answer is F the reasons are as following
1. ability to add indexes to the secondary database
This will eliminate Logshipping (NORECOVERY or STANDBY), Active Secondary in available group (NORECOVERY), only Replication can have RECOVERY restoring state.
Database cann’t be changed in NORECOVERY or STANDBY state.
2.up-to-the-minute reporting requirements
Logshipping has latency longer than 1 minute. Snapshot replication also longer.
3. Windows Failover Cluster
Itself alone without active secondary is not a reporting solution.
This leaves F transactional replication ( RECOVERY state and latency of few seconds the only option.