nerdexam
Microsoft

70-457 · Question #79

You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database contains two tables that have the following definitions: Global customers place orders from…

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

Question

You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database contains two tables that have the following definitions:

Global customers place orders from several countries. You need to view the country from which each customer has placed the most orders. Which Transact-SQL query do you use?

Exhibits

70-457 question #79 exhibit 1
70-457 question #79 exhibit 2

Options

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

How the community answered

(43 responses)
  • A
    77% (33)
  • B
    12% (5)
  • C
    5% (2)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice