Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
The data engineering team has observed significant slowdowns in most general queries on a partitioned Delta Lake table. Despite running an OPTIMIZE command, the issue persists. What is the most likely cause of these slowdowns?
The data engineering team has observed significant slowdowns in most general queries on a partitioned Delta Lake table. Despite running an OPTIMIZE command, the issue persists. What is the most likely cause of these slowdowns?
Real Exam
A
The transaction log is too large. Log files older than a certain age must be deleted or archived at partition boundaries.
5.0%
B
They are applying the OPTIMIZE command without ZORDER. Z-ordering is needed on the partitioning columns.
13.5%
C
Comments
Loading comments...