Certified Data Engineer Associate Delta Practice Questions

Which of the following describes the storage organization of a Delta table?

• AA. Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• BB. Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
• CC. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• DD. Delta tables are stored in a collection of files that contain only the data stored within the table.

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance. Which of the following keywords can be used to compact the small files?

• AA. REDUCE
• BB. OPTIMIZE
• CC. COMPACTION
• DD. REPARTITION