Exam Certified Data Engineer Professional topic 1 question 10 discussion

Answer D: In the Transaction log, Delta Lake captures statistics for each data file of the table. These statistics indicate per file: - Total number of records - Minimum value in each column of the first 32 columns of the table - Maximum value in each column of the first 32 columns of the table - Null value counts for in each column of the first 32 columns of the table When a query with a selective filter is executed against the table, the query optimizer uses these statistics to generate the query result. it leverages them to identify data files that may contain records matching the conditional filter. For the SELECT query in the question, The transaction log is scanned for min and max statistics for the price column

Since the table is not partitioned on Latitude Delta log is used. If latitude was a partition column then Parquet footers would come into play.

In the Transaction log, Delta Lake captures statistics for each data file of the table. These statistics indicate per file: - Total number of records - Minimum value in each column of the first 32 columns of the table - Maximum value in each column of the first 32 columns of the table - Null value counts for in each column of the first 32 columns of the table

suretly D

elta extracts stats from the Parquet footers at write time and stores them in _delta_log. At query time, Delta reads the stats from the log instead of scanning file footers = faster performance.This is what enables efficient data skipping and query optimization.

B is correct! Delta Lake stores min/max statistics for each column in the Parquet file footers. The engine scans these footers to determine if a file contains any data that satisfies the latitude > 66.3 condition. If the minimum latitude in a file is greater than 66.3, the file is loaded. If the maximum latitude is less than or equal to 66.3, the file is skipped.

Above mentioned points are correct. If the table was just parquet table then parquet file footer have been used. But since this is Delta table, then delta log is used to scan & skip files. It uses stats written in in transaction log.

Answer D : Delta data skipping automatically collects the stats (min, max, etc.) for the first 32 columns for each underlying Parquet file when you write data into a Delta table. Databricks takes advantage of this information (minimum and maximum values) at query time to skip unnecessary files in order to speed up the queries. https://www.databricks.com/discover/pages/optimize-data-workloads-guide#delta-data

Delta table stores file statistics in transaction log

No explanation needed, this is where the information is stored.

D. The Delta log is scanned for min and max statistics for the latitude column

Delta log collects statistics like min value, max value, no of records, no of files for each transaction that happens on the table for the first 32 columns (default value)

D is the answer

Based on Docu is D I don't know why here is showing B

Delta log first

Statistics on first 32 columns of a table are computed and written in the Delta Log by default.

D is the right answer