Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A Delta Lake table with the schema user_id LONG, post_text STRING, post_id STRING, longitude FLOAT, latitude FLOAT, post_time TIMESTAMP, date DATE is partitioned by the date column. When executing a query with the filter condition longitude < 20 AND longitude > -20, how will the data be filtered?
A
Statistics in the Delta Log will be used to identify partitions that might Include files in the filtered range.
B
No file skipping will occur because the optimizer does not know the relationship between the partition column and the longitude.
C
The Delta Engine will scan the parquet file footers to identify each row that meets the filter criteria.
D
Statistics in the Delta Log will be used to identify data files that might include records in the filtered range.