A data engineer has just created a Delta table from a large Parquet file and wants to ensure that queries on a frequently filtered column benefit from data skipping. What is the first step they should take?

Run ANALYZE TABLE COMPUTE STATISTICS

A Delta table stores IoT sensor readings. Queries often filter on sensor_id (high cardinality) and timestamp (high cardinality). The table is not partitioned. Which optimization should be applied to improve data skipping for both filter columns?

Z-order by (sensor_id, timestamp)

What information is used by file pruning to skip entire files during a query?

The file's creation timestamp and last modified time

The file's size and compression ratio

Column-level statistics such as minimum and maximum values for each file

The number of rows in each file

A Delta table is partitioned by country and date. Queries always filter on date and sometimes on product_id (a high-cardinality column). The table has many small files. Which optimization strategy will most effectively reduce the amount of data scanned?

Z-order by product_id within each partition

Partition by product_id instead of country

What is the purpose of Bloom filter indexing in Databricks?

To cache query results for repeated executions

To sort data within files to improve min/max statistics

To compress data files to reduce storage

To quickly determine if a file might contain a specific value, enabling file skipping

DatabricksCertified Data Engineer Professional

Domain 6Objective 3

Understand the Optimization Techniques Used by Databricks to Ensure the Performance of Queries on Large Datasets (data Skipping, File Pruning, Etc.). DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 2)

Part of the Cost & Performance Optimization domain, which accounts for 13% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~7–10 in this domain), expect 1–2 from this objective — we provide 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

8concepts

13%of the exam

Questions 6–10

6application · medium
A data engineer has just created a Delta table from a large Parquet file and wants to ensure that queries on a frequently filtered column benefit from data skipping. What is the first step they should take?
Select an answer first
7application · medium
A Delta table stores IoT sensor readings. Queries often filter on sensor_id (high cardinality) and timestamp (high cardinality). The table is not partitioned. Which optimization should be applied to improve data skipping for both filter columns?
Select an answer first
8foundation · easy
What information is used by file pruning to skip entire files during a query?
Select an answer first
9expert · hard
A Delta table is partitioned by country and date. Queries always filter on date and sometimes on product_id (a high-cardinality column). The table has many small files. Which optimization strategy will most effectively reduce the amount of data scanned?
Select an answer first
10foundation · easy
What is the purpose of Bloom filter indexing in Databricks?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-PROFESSIONAL

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.