Databricks Certified Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — Rows sort ascending by category first, then within each category tie sort descending by price, since ORDER BY accepts SELECT-list positions per key A . Correct: ORDER BY supports referencing SELECT-list columns by their integer position, so 2 refers to category and 3 refers to price; each key sorts independently unless a shared direction is stated, so category sorts ascending by default while price sorts descending as explicitly marked. B . Incorrect: Databricks SQL explicitly supports ordering by column position as an alternative to naming the column or alias directly, so this query parses and runs successfully. C . Incorrect: a DESC keyword only applies to the sort key it immediately follows; it does not retroactively apply to earlier keys in the same ORDER BY list, so category still sorts ascending here. D . Incorrect: positional references are fully honored by ORDER BY rather than ignored, and product_id is never used as a sort key in this query since it was not referenced by position or name.