nerdexam
Microsoft

70-451 · Question #61

You need to design a database solution that meets the following requirements: - Supports different types of databases - Provides reliable messaging between databases - Provides data workload…

The correct answer is D. Service Broker. See the full explanation below for the reasoning.

Question

You need to design a database solution that meets the following requirements:

  • Supports different types of databases
  • Provides reliable messaging between databases
  • Provides data workload distribution across several databases

Which SQL Server component should you use?

Options

  • ASQL Server Agent
  • BSQL Mail
  • CNotification Services
  • DService Broker

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    7% (2)
  • C
    11% (3)
  • D
    79% (22)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice