Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Quick Answer

Answer-first summary for fast verification

Answer: 1024 MB

The OPTIMIZE command is used to compact small data files into larger ones. The default target file size is set to 1 GB (1024 MB). This is specified by the default value of 1073741824 bytes. For more details, refer to the [Databricks documentation](https://docs.databricks.com/sql/language-manual/delta-optimize.html).

Author: LeetQuiz Editorial Team

Quick Answer

Answer-first summary for fast verification

Answer: 1024 MB

The OPTIMIZE command is used to compact small data files into larger ones. The default target file size is set to 1 GB (1024 MB). This is specified by the default value of 1073741824 bytes. For more details, refer to the [Databricks documentation](https://docs.databricks.com/sql/language-manual/delta-optimize.html).

Author: LeetQuiz Editorial Team

Comments (0)

No comments yet.

Get started today

Ultimate access to all questions.

What is the default target file size when compacting small files of a Delta table by manually running the OPTIMIZE command?

Real Exam

0

A

64 MB

10.5%

B

512 MB

10.5%

C

128 MB

19.5%

D

1024 MB

46.5%

E

256 MB

13.0%

Powered ByGPT 5.4

Comments (0)

No comments yet.