CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #10
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
A Delta table of weather records is partitioned by date and has the below schema: date DATE, device_id INT, temp FLOAT, latitude FLOAT, longitude FLOAT To find all the records from within the Arctic Circle, you execute a query with the below filter: latitude > 66.3 Which statement describes how the Delta engine identifies which files to load?
Options
- AAll records are cached to an operational database and then the filter is applied
- BThe Parquet file footers are scanned for min and max statistics for the latitude column
- CAll records are cached to attached storage and then the filter is applied
- DThe Delta log is scanned for min and max statistics for the latitude column
- EThe Hive metastore is scanned for min and max statistics for the latitude column
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.