DP-500 · Question #145
DP-500 Question #145: Real Exam Question with Answer & Explanation
Sign in or unlock DP-500 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.
Question
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.DimProduct. You need to write a query to meet the following requirements: - Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties. - Specify the quartile in which each product's list price falls within each product category. How should you complete the query? To answer, select the appropriate options in the answer area.
Unlock DP-500 to see the answer
You've previewed enough free DP-500 questions. Unlock DP-500 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.