
Ultimate access to all questions.
You are working with a large dataset stored in a Delta table that is experiencing slow query performance. Describe how you would analyze the structure of the Delta table to identify potential performance issues and what steps you would take to resolve them. Consider factors such as partitioning, data skewness, and file size.
A
Re-partition the Delta table based on commonly queried columns.
B
Increase the number of small files to improve parallelism.
C
Use data skipping techniques to reduce the amount of data read.
D
Compress the Delta table files to reduce their size.