QUESTION 29
You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation.
You need to consolidate the underlying Parquet files in Table1.
Which command should you run?

Question

Accepted Answer

C. OPTIMIZE The OPTIMIZE command in Delta Lake is specifically designed to rewrite data files to consolidate many small files into fewer, larger files. This process significantly improves query performance by reducing the overhead of reading numerous small files, which is a common issue with frequent data writes or merges.

Answer

A. VACUUM VACUUM is used to remove old, unreferenced data files from a Delta table, not to consolidate existing files.

Answer

B. BROADCAST BROADCAST is a Spark SQL hint for query optimization in join operations, not a command for file management or consolidation.

Answer

D. CACHE CACHE is used to store data in memory or on disk for faster retrieval, not to consolidate the physical data files themselves.

QUESTION 29 You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic…

Question

Options

How the community answered

Why each option

Topics

Community Discussion