Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Engineer Professional Exam - Topic 6 Question 55 Discussion

Posted by Kayleigh on Oct 01, 2026 at 04:44 PM

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 DATE

This table is partitioned by the date column. A query is run with the following filter:

longitude < 20 and longitude > -20

Which statement describes how data will be filtered?

Suggested Answer: D

This is the correct answer because it describes how data will be filtered when a query is run with the following filter: longitude < 20 and longitude > -20. The query is run on a Delta Lake table that has the following schema: user_id LONG, post_text STRING, post_id STRING, longitude FLOAT, latitude FLOAT, post_time TIMESTAMP, date DATE. This table is partitioned by the date column. When a query is run on a partitioned Delta Lake table, Delta Lake uses statistics in the Delta Log to identify data files that might include records in the filtered range. The statistics include information such as min and max values for each column in each data file. By using these statistics, Delta Lake can skip reading data files that do not match the filter condition, which can improve query performance and reduce I/O costs. Verified Reference: [Databricks Certified Data Engineer Professional], under ''Delta Lake'' section; Databricks Documentation, under ''Data skipping'' section.


Get Premium Databricks Certified Data Engineer Professional Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
9 comments · newest first
TY
Ty 3 days ago
D) is the best choice, it’s all about identifying files!
PA
Paris 8 days ago
C) sounds right, row-level stats are key here.
ER
Ernie 14 days ago
Wait, how does the optimizer not know about longitude?
AN
Anglea 19 days ago
I think B) makes sense too, no relation to longitude.
PA
Pansy 24 days ago
A) is correct, it uses partition stats!
AL
Alison 29 days ago
I'm a bit confused about the role of the Delta Engine in this case. Does it really scan the parquet file footers for every row? That seems inefficient.
VI
Vi 1 month ago
I practiced a similar question where we discussed how Delta Lake uses statistics for filtering, so I feel like option D could be correct here.
SU
Sueann 1 month ago
I think option B makes sense because the optimizer might not be able to skip files based on the longitude filter alone.
NI
Nichelle 1 month ago
I remember that Delta Lake uses partitioning to optimize queries, but I'm not sure how it applies to longitude filtering since it's not a partitioned column.
0/2000 characters

Save Cancel