Microsoft
70-457 · Question #104
You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire…
The correct answer is E. SQL Server that includes an application database configured to perform snapshot replication. See the full explanation below for the reasoning.
Question
You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?
Options
- ATwo servers configured in the same data center
- BSQL Server that includes an application database configured to perform transactional replication
- CTwo servers configured in the same data center
- DTwo servers configured in a Windows Failover Cluster in the same data center
- ESQL Server that includes an application database configured to perform snapshot replication
- FTwo servers configured in different data centers
- GTwo servers configured on the same subnet
- HTwo servers configured in different data centers
How the community answered
(43 responses)- A5% (2)
- B9% (4)
- E84% (36)
- F2% (1)
Community Discussion
No community discussion yet for this question.