nerdexam
Microsoft

70-433 · Question #468

A table named Locations contains 5000 locations and the number of sales made at each location. You need to display the top 5 percent of locations by sales made. Which Transact-SQL code segment…

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

Question

A table named Locations contains 5000 locations and the number of sales made at each location. You need to display the top 5 percent of locations by sales made. Which Transact-SQL code segment should you use?

Exhibit

70-433 question #468 exhibit

Options

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

How the community answered

(25 responses)
  • A
    80% (20)
  • B
    4% (1)
  • C
    12% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice