Utilize Delta Lake to Audit and View History, Validate Results, and Compare Historical Results or Trends. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which column in DESCRIBE HISTORY output provides information about the number of rows added or deleted by an operation?

   • Aoperation
   • BuserMetadata
   • Ctimestamp
   • DoperationMetrics
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is a common pattern for computing a metric across multiple versions of a Delta table?

   • AUse the HISTORY command to compute the metric
   • BRun a separate aggregation query on each version and combine the results
   • CUse the VERSION function to get the metric directly
   • DQuery the current version only and extrapolate
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data analyst is auditing a Delta table and runs DESCRIBE HISTORY. The output shows a version with operation 'WRITE' and operationParameters containing 'mode' = 'overwrite'. The analyst needs to understand the impact of this operation on the table's data. What does this metadata indicate?

   • AThe operation deleted all rows that were older than a certain date.
   • BThe operation replaced all existing data in the table with the new data written at that version.
   • CThe operation only updated rows that matched a specific condition.
   • DThe operation appended new data to the existing table without affecting prior rows.
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A data analyst is investigating a data discrepancy and needs to understand the sequence of operations that led to the current state of the `orders` Delta table. The analyst wants to see the exact order of operations, including the user who performed each operation and the metrics for each operation. What should the analyst use?

   • ADESCRIBE HISTORY orders
   • BSELECT * FROM orders VERSION AS OF 0
   • CSHOW TABLES
   • DSELECT * FROM orders
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A data analyst is auditing a Delta table and runs DESCRIBE HISTORY. The output shows a version with operation 'MERGE' and operationParameters containing 'predicate' = '["(id = \"123\")"]'. The analyst needs to understand what this operation did. What does this metadata indicate?

   • AThe operation deleted the row with id '123'.
   • BThe operation overwrote the entire table with new data.
   • CThe operation performed an upsert, inserting or updating the row with id '123' based on the predicate.
   • DThe operation appended new rows to the table.
   Reveal Solution Discussion Select an answer first