nerdexam
Microsoft

70-451 · Question #69

You have a table named Sales that contains the data listed in the following table. You need design a query that retrieves a list that contains all sales people that have top three values from the…

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

Question

You have a table named Sales that contains the data listed in the following table. You need design a query that retrieves a list that contains all sales people that have top three values from the TotalSales column. Which query should you design?

Exhibits

70-451 question #69 exhibit 1
70-451 question #69 exhibit 2

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    17% (5)
  • C
    73% (22)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice