nerdexam
Microsoft

70-451 · Question #139

You have an office in Tokyo and an office in New York. Each office contains a server that runs SQL Server 2008 Enterprise. The New York office contains a central database that is mirrored to the…

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

Question

You have an office in Tokyo and an office in New York. Each office contains a server that runs SQL Server 2008 Enterprise. The New York office contains a central database that is mirrored to the Tokyo office for high-availability. You need to recommend a solution that enables users in the Tokyo office to generate reports locally. The solution must minimize WAN utilization. What should you recommend?

Options

  • AImplement a failover cluster.
  • BCreate distributed partitioned views.
  • CCreate database snapshots.
  • DImplement snapshot replication.

How the community answered

(52 responses)
  • A
    13% (7)
  • B
    8% (4)
  • C
    75% (39)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice