nerdexam
Databricks

CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #22

Which statement describes Delta Lake Auto Compaction?

The correct answer is E. An asynchronous job runs after the write completes to detect if files could be further compacted; if. This is the correct answer because it describes the behavior of Delta Lake Auto Compaction, which is a feature that automatically optimizes the layout of Delta Lake tables by coalescing small files into larger ones. Auto Compaction runs as an asynchronous job after a write to a t

Delta Lake Features and Performance Optimization

Question

Which statement describes Delta Lake Auto Compaction?

Options

  • AAn asynchronous job runs after the write completes to detect if files could be further compacted; if
  • BBefore a Jobs cluster terminates, optimize is executed on all tables modified during the most
  • COptimized writes use logical partitions instead of directory partitions; because partition boundaries
  • DData is queued in a messaging bus instead of committing data directly to memory; all data is
  • EAn asynchronous job runs after the write completes to detect if files could be further compacted; if

How the community answered

(30 responses)
  • A
    3% (1)
  • C
    3% (1)
  • E
    93% (28)

Explanation

This is the correct answer because it describes the behavior of Delta Lake Auto Compaction, which is a feature that automatically optimizes the layout of Delta Lake tables by coalescing small files into larger ones. Auto Compaction runs as an asynchronous job after a write to a table has succeeded and checks if files within a partition can be further compacted. If yes, it runs an optimize job with a default target file size of 128 MB. Auto Compaction only compacts files that have not been compacted previously.

Topics

#Delta Lake#Auto Compaction#Data Optimization#File Management

Community Discussion

No community discussion yet for this question.

Full CERTIFIED-DATA-ENGINEER-PROFESSIONAL Practice