Easily Pass 70-457 Exam with the Help of Lead2pass New Microsoft 70-457 VCE and PDF Dumps (11-20)
Passing Microsoft 70-457 exam questions is guaranteed with Lead2pass. Lead2pass provides a great deal of Microsoft 70-457 preparation resources mend to step up your career with the endorsement of technical proficiency. The earlier you use Lead2pass products, the quicker you pass you 70-457 exam.
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 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?