nerdexam
Microsoft

70-457 · Question #11

Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The…

The correct answer is A. Option A. optimal-performance-comparison/

Design an optimized database solution

Question

Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number of global sales and total sales amounts. You need to ensure that your query executes in the minimum possible time. Which query should you use?

Exhibit

70-457 question #11 exhibit

Options

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

How the community answered

(20 responses)
  • A
    75% (15)
  • B
    10% (2)
  • C
    5% (1)
  • D
    10% (2)

Explanation

optimal-performance-comparison/

Topics

#query optimization#aggregate queries#large tables#parallel execution

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice