Skip to content
DEP
Cost & Performance Optimisation
easy
Question 2 of 26

What is the primary purpose of running the OPTIMIZE command on a Delta table?

ARebuilding table statistics used by the Databricks cost-based query planner
BCompacting many small Parquet files into fewer, larger files to improve read query performance
CRemoving soft-deleted rows to reclaim storage space from the table
DRe-encrypting table data with the latest encryption key version

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.

Sign in to join the discussion