Câu 42: Databricks Certified Data Engineer Professional

A Delta Lake table representing metadata about content posts from users has the following schema: user_id LONG, post_text STRING, post_id STRING, longitude FLOAT, latitude FLOAT, post_time TIMESTAMP, date DATEThis table is partitioned by the date column. A query is run with the following filter: longitude -20Which statement describes how data will be filtered?

1. A. Statistics in the Delta Log will be used to identify partitions that might Include files in the filtered range.
2. B. No file skipping will occur because the optimizer does not know the relationship between the partition column and the longitude.
3. C. The Delta Engine will use row-level statistics in the transaction log to identify the flies that meet the filter criteria.
4. D. Statistics in the Delta Log will be used to identify data files that might include records in the filtered range. — đáp án hiện tại
5. E. The Delta Engine will scan the parquet file footers to identify each row that meets the filter criteria.