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 — `DESCRIBE HISTORY pricing;` to list each commit's version, timestamp, operation type, and the user or job that performed it A . Correct: `DESCRIBE HISTORY` returns the audit trail of a Delta table's operations, including version, timestamp, operation type, and the user or job identity, making it the direct way to identify which commits to inspect further. B . Incorrect: `SHOW TBLPROPERTIES` returns configuration settings such as retention durations, not a log of individual write events, so it cannot reveal who changed what or when. C . Incorrect: reading only the earliest version and manually diffing every row against the current table is a slow, error-prone substitute for the operation log and would not surface the acting user or job for each change. D . Incorrect: `EXPLAIN` shows the physical or logical execution plan for the current query, not a historical record of past write operations performed on the table.