What does Auto Optimize do to maintain table performance with minimal manual intervention?

Automatically caches tables in memory for faster queries

Automatically partitions tables based on query patterns

Automatically Z-orders tables on frequently filtered columns

Automatically compacts small files and applies optimized writes

A team manages a Delta table that receives frequent appends from multiple concurrent writers. They want to minimize small file creation and avoid manual maintenance. Which configuration should they enable?

Z-order by a frequently filtered column

Partition by a high-cardinality column

Set spark.sql.shuffle.partitions to a high value

A data engineer notices that a Delta table query filtering on a string column is scanning far more files than expected. The table was recently created from a large Parquet export, and no statistics have been collected. Which action should be taken to enable effective data skipping?

Run ANALYZE TABLE COMPUTE STATISTICS

Create a Bloom filter index on the string column

What is the primary benefit of Z-ordering a Delta table on a high-cardinality column?

It reduces the number of files in the table

It eliminates the need for partitioning

It improves data skipping by clustering similar values together in files

It compresses the data to reduce storage

What type of statistics are collected for each file in a Delta table to support data skipping?

Minimum and maximum values for each column

The exact list of distinct values in each column

The number of partitions in the table

The compression ratio of each file

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 4)

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 16–20

16foundation · easy
What does Auto Optimize do to maintain table performance with minimal manual intervention?
Select an answer first
17application · medium
A team manages a Delta table that receives frequent appends from multiple concurrent writers. They want to minimize small file creation and avoid manual maintenance. Which configuration should they enable?
Select an answer first
18application · medium
A data engineer notices that a Delta table query filtering on a string column is scanning far more files than expected. The table was recently created from a large Parquet export, and no statistics have been collected. Which action should be taken to enable effective data skipping?
Select an answer first
19foundation · easy
What is the primary benefit of Z-ordering a Delta table on a high-cardinality column?
Select an answer first
20foundation · easy
What type of statistics are collected for each file in a Delta table to support data skipping?
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.