nerdexam
Microsoft

70-433 · Question #193

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as follows: You need…

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

Question

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as follows:

You need to write a query to sum the sales made to each customer who has made a complaint by the following entries:

Which SQL query should you use?

Exhibits

70-433 question #193 exhibit 1
70-433 question #193 exhibit 2
70-433 question #193 exhibit 3

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D
  • EOption E
  • FOption F
  • GOption G
  • HOption H
  • JOption J

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    83% (25)
  • F
    7% (2)
  • J
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice