Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

Access More Questions

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?

GROUP BY `order_id` and keep `MAX(updated_at)` without returning the full row Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1` Use `DISTINCT order_id` after selecting all columns Sort the table by `updated_at` and apply `LIMIT 1`

Correct Answer:

Use `ROW_NUMBER()` over `PARTITION BY order_id ORDER BY updated_at DESC` and filter to `rn = 1`

Access more questions from this quiz

Continue to Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam for more practice questions and the full quiz experience.

Access More Questions