Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Databricks Certified Data Engineer Associate · Databricks
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- RANK() assigns the same rank to tied values but leaves gaps in the sequence (1, 1, 3, 4...). ROW_NUMBER() assigns unique numbers regardless of ties (1, 2, 3, 4...). DENSE_RANK() assigns the same rank to ties with no gaps (1, 1, 2, 3...). NTILE() distributes rows into a specified number of buckets.