Microsoft
70-458 · Question #60
70-458 Question #60: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
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
- 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
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.