70-461 Exam Dumps | Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables

<< Prev Question Next Question >>

Question 70/111

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?
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount

A. FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION ALL
SELECT SalesOrderId, SalesAmount
FROM InternationalSalesOrders
) AS p
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount

B. FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION
SELECT SalesOrderId, SalesAmount
FROM InternationalSalesOrders
) AS p
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount

C. FROM DomesticSalesOrders
UNION
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
FROM InternationalSalesOrders
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount

D. FROM DomesticSalesOrders
UNION ALL
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount
FROM InternationalSalesOrders

Question 70/111

LEAVE A REPLY

Download PDF File