How does the Delta engine determine which files to load when querying a Delta table partitioned by date with the schema: date DATE, device_id INT, temp FLOAT, latitude FLOAT, longitude FLOAT, using the filter condition latitude > 66.3 to find records within the Arctic Circle?_

Exam-Like

All records are cached to an operational database and then the filter is applied

4.9%

The Parquet file footers are scanned for min and max statistics for the latitude column

49.7%

All records are cached to attached storage and then the filter is applied

5.9%

The Delta log is scanned for min and max statistics for the latitude column

29.2%

The Hive metastore is scanned for min and max statistics for the latitude column

10.3%

Databricks Certified Data Engineer - Professional