DATABRICKS-DEP Question 3

Question

A silver-layer SQL transform must retain exactly one latest order record per `order_id` using `updated_at`. Which Spark SQL pattern is the most reliable?
A. GROUP BY `order_id` and keep `MAX(updated_at)` without returning the full row
B. Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1`
C. Use `DISTINCT order_id` after selecting all columns
D. Sort the table by `updated_at` and apply `LIMIT 1`

Accepted Answer

Marked answer: B. Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1`

DATABRICKS-DEP Question 3

Community Discussion

Preparing Practice Exam…

DATABRICKS-DEP Question 3

Community Discussion