Microsoft
70-433 · Question #43
70-433 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
You work for an international charity organization. You are writing a query to list the highest 100 different amounts that were donated. You have written the following code segment (Line numbers are included for reference only): 01 SELECT * 02 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven, 03 .................... 04 FROM Customer 05 JOIN SalesOrder 06 ON Customer.CustomerID = SalesOrder.CustomerID 07 GROUP BY Customer.CustomerID) AS DonationsToFilter 08 WHERE FilterCriteria <= 100 You need to insert a Transact-SQL clause in line 03 to complete the query. Which Transact-SQL clause should you insert?
Options
- ARANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
- BNTILE(100) OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
- CROW_NUMBER() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
- DDENSE_RANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.