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?

Real Exam

The table does not leverage file skipping because Delta Lake statistics are uninformative for string fields with very high cardinality.

73.4%

The table does not leverage file skipping because it's not partitioned on the 'msg_body' column._

7.4%

The table does not leverage file skipping because Delta Lake statistics are not captured on columns of type STRING.

11.7%

The table does not leverage file skipping because it's not optimized with Z-ORDER on the 'msg_body' column._

6.4%

The table does not leverage file skipping because Delta Lake statistics are only captured on the first 3 columns in a table.

1.1%

Databricks Certified Data Engineer - Professional