nerdexam
Microsoft

70-458 · Question #58

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 C. SQL Server that includes an application database configured to perform snapshot. 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
  • BTwo servers configured in the same data center
  • CSQL Server that includes an application database configured to perform snapshot
  • DTwo servers configured in different data centers
  • ETwo servers configured on the same subnet
  • FTwo servers configured in different data centers
  • GSQL Server that includes an application database configured to perform transactional
  • HTwo servers configured in a Windows Failover Cluster in the same data center

How the community answered

(34 responses)
  • B
    15% (5)
  • C
    74% (25)
  • D
    6% (2)
  • F
    3% (1)
  • H
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice