
Ultimate access to all questions.
You are working with a Delta table that is experiencing slow query performance due to a large number of small files. Describe how you would identify this issue and what steps you would take to resolve it. Specifically, discuss the use of optimized writes and compaction techniques.
A
Use optimized writes to minimize data shuffling during writes.
B
Increase the number of partitions in the Delta table.
C
Compress the Delta table files to reduce their size.
D
Use data skipping techniques to reduce the amount of data read.