Exam Databricks-Certified-Data-Analyst-Associate Topic 2 Question 45 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam
Question #: 45
Topic #: 2

A data analyst has been asked to use the below table sales_table to rank products within region by the sales.
Input table:
region product sales
WEST A 1880.59
EAST A 2045.99
EAST B 4583.23
WEST B 3391.19
The result of the query should look like this:
region product rank
EAST B 1
EAST A 2
WEST B 1
WEST A 2
Which query will accomplish this task?

A. SELECT region, product, RANK() OVER ( ORDER BY sales DESC ) AS rankFROM sales_table; B. SELECT region, product, RANK() OVER ( PARTITION BY product ORDER BY sales DESC ) AS rankFROM sales_table; C. SELECT region, product, RANK() OVER ( PARTITION BY region ) AS rankFROM sales_table; D. SELECT region, product, RANK() OVER ( PARTITION BY region ORDER BY sales DESC ) AS rankFROM sales_table; E. Option A F. Option B G. Option C H. Option D

Suggested Answer: D Vote an answer

Option D is correct. The phrase "rank products within region by the sales" means each region must be ranked separately, so the window must use PARTITION BY region. The ranking must be based on highest sales first, so the window must use ORDER BY sales DESC. Option A ranks across all regions together. Option B ranks within product, not within region. Option C does not specify the sales ordering. Official Databricks extract:
rank() "returns the rank of a value compared to all values in the partition," and its OVER clause must include ORDER BY.

by Clark at Sep 07, 2026, 03:14 PM

Limited Time Offer

15%

Off

Get Premium Databricks-Certified-Data-Analyst-Associate Questions as Interactive Self Test Engine or PDF

Comments

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.