Databricks Certified Associate Developer for Apache Spark Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - OPTIMIZE mytable compacts many small Delta files into a few larger ones, improving scan performance. OPTIMIZE mytable ZORDER BY col clusters rows by col for data skipping. VACUUM removes old files past the retention threshold. REPAIR is for table metadata reconstruction.