To enhance query performance on a Delta table named 'voters' where columns 58 and 59 are frequently used for highly selective filters, what strategy should a data engineer employ during table creation, considering the need to minimize overhead as new records are added?

Real Exam

Increase the value of 'delta.dataSkippingNumIndexedCols' to 59 to enable statistics collection for the first 59 columns.

12.3%

No action is required since statistics are automatically collected for all columns in a Delta table by default.

7.4%

Reposition columns 58 and 59 within the first 16 columns to leverage automatic statistics collection for these columns.

9.9%

Adjust the 'delta.dataSkippingNumIndexedCols' setting to 2 to focus statistics collection on the two columns in question.

8.6%

Move columns 58 and 59 into the first 32 columns to utilize the default statistics collection for the initial 32 columns.

61.7%

Databricks Certified Data Engineer - Professional