Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
The data engineering team is experiencing performance issues with a large Delta table named 'user_messages' when queries include filters on the 'msg_body' field, which contains free-form text. What could be the reason for this performance issue?
A
The table does not leverage file skipping because Delta Lake statistics are uninformative for string fields with very high cardinality.
B
The table does not leverage file skipping because it's not partitioned on the 'msg_body' column.
C
The table does not leverage file skipping because Delta Lake statistics are not captured on columns of type STRING.
D
The table does not leverage file skipping because it's not optimized with Z-ORDER on the 'msg_body' column.
E
The table does not leverage file skipping because Delta Lake statistics are only captured on the first 3 columns in a table.
