Which of the following is true of Delta Lake and the Lakehouse?

Question

Options

• ABecause Parquet compresses data row by row. strings will only be compressed when a character
• BDelta Lake automatically collects statistics on the first 32 columns of each table which are
• CViews in the Lakehouse maintain a valid cache of the most recent versions of source tables at all
• DPrimary and foreign key constraints can be leveraged to ensure duplicate values are never
• EZ-order can only be applied to numeric values stored in Delta Lake tables

• A
  2% (1)
• B
  92% (55)
• C
  5% (3)
• E
  2% (1)

Explanation

Delta Lake automatically collects column-level statistics-specifically minimum value, maximum value, and null count-on the first 32 columns of each Delta table. These statistics are stored in the Delta transaction log alongside each data file. During query execution, the Delta engine uses these statistics to perform data skipping: files whose min/max ranges cannot contain values matching a query predicate are skipped entirely without being read, dramatically reducing I/O. Choice A is false (Parquet uses column-level, not row-level compression). Choice C is false (views are not cached). Choice D is false (primary/foreign key constraints in Databricks are informational only and not enforced). Choice E is false (Z-order works on any orderable data type, not just numeric).

No community discussion yet for this question.