Microsoft
70-457 · Question #102
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 correct answer is F. SQL Server that includes an application database configured to perform transactional replication. See the full explanation below for the reasoning.
Question
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?
Options
- ATwo servers configured in different data centers
- BTwo servers configured in the same data center
- CTwo servers configured in the same data center
- DTwo servers configured in different data centers
- ETwo servers configured on the same subnet
- FSQL Server that includes an application database configured to perform transactional replication
- GSQL Server that includes an application database configured to perform snapshot replication
- HTwo servers configured in a Windows Failover Cluster in the same data center
How the community answered
(24 responses)- C8% (2)
- D8% (2)
- E4% (1)
- F79% (19)
Community Discussion
No community discussion yet for this question.