Content Section — Worksheet Questions

Concurrency Control — What concurrency control method uses version checks before committing?

• MVCC

• OCC

• TwoPhase

• Snapshot

Iceberg Metadata — What Iceberg metadata file contains column-level statistics?

• Snapshot

• Schema

• Manifest

• Catalog

File Layout Optimization — What technique reorganizes data files to improve read performance?

• Compaction

• Indexing

• Partitioning

• Clustering

Architecture Principle — Where is the current metadata pointer reference stored in Iceberg?

• Manifest

• Catalog

• Compute engine

• Storage

Streaming Ingestion — What data capture pattern records row-level changes from databases?

• ETL

• Snapshot

• CDC

• Replication

Query Optimization — What statistics enable skipping irrelevant data during scans?

• Bloom

• Histogram

• MinMax

• Cardinality

Governance & Metadata — What central service manages table namespaces and versions?

• Metastore

• Registry

• Coordinator

• Catalog