nerdexam
Microsoft

70-451 · Question #72

You have a server that runs SQL Server 2008 Enterprise. The server contains a 300-GB database. At the end of every month, several reports are generated from the database. Users report that it takes…

The correct answer is B. database snapshots. See the full explanation below for the reasoning.

Question

You have a server that runs SQL Server 2008 Enterprise. The server contains a 300-GB database. At the end of every month, several reports are generated from the database. Users report that it takes a long time to access data from the database while the reports are being generated. You need to recommend a solution to improve the data access time while the reports are being generated from the database. The solution must use a minimum amount of administrative effort. What should you recommend?

Options

  • Alinked servers
  • Bdatabase snapshots
  • Ca failover cluster
  • Ddatabase mirroring

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    72% (26)
  • C
    17% (6)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice