What does ACID stand for in the context of Delta Lake transactions?

Atomicity, Concurrency, Isolation, Durability

Accuracy, Consistency, Integrity, Durability

Atomicity, Consistency, Isolation, Durability

Availability, Consistency, Integrity, Durability

A data engineering team manages a Delta Lake table that ingests IoT sensor readings. The schema currently has columns `device_id`, `timestamp`, and `value`. A new sensor model sends an additional `unit` column. The team wants to allow the new column while preventing other unintended schema changes. What should they do?

Enable schema evolution and set `spark.databricks.delta.schema.autoMerge.enabled` to true

Manually ALTER TABLE to add the `unit` column, keeping schema enforcement enabled

Set `spark.databricks.delta.schema.autoMerge.enabled` to false and rely on schema enforcement

Drop and recreate the table with the new schema

What is the primary purpose of data skipping in Delta Lake?

To automatically fix schema mismatches

To compress data files to save storage

To avoid reading files that do not contain relevant data for a query

To speed up writes by skipping the transaction log

DatabricksCertified Data Engineer Professional

Domain 10Objective 1

Design and Implement Scalable Data Models Using Delta Lake to Manage Large Datasets. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Part of the Data Modeling domain, which accounts for 6% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~3–5 in this domain), expect 1–1 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here

6free pages

7concepts

6%of the exam

Questions 11–15

11foundation · easy
What does ACID stand for in the context of Delta Lake transactions?
Select an answer first
12application · medium
A data engineering team manages a Delta Lake table that ingests IoT sensor readings. The schema currently has columns `device_id`, `timestamp`, and `value`. A new sensor model sends an additional `unit` column. The team wants to allow the new column while preventing other unintended schema changes. What should they do?
Select an answer first
13foundation · easy
What is the primary purpose of data skipping in Delta Lake?
Select an answer first
14foundation · easy
Which Delta Lake feature ensures that concurrent writes to the same table do not corrupt data and that each transaction is applied in a serializable manner?
Select an answer first
15foundation · easy
Which Delta Lake feature relies on statistics such as minimum and maximum values to reduce the number of files scanned during a query?
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.

Design and Implement Scalable Data Models Using Delta Lake to Manage Large Datasets. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Questions 11–15

What does ACID stand for in the context of Delta Lake transactions?

What is the primary purpose of data skipping in Delta Lake?

Which Delta Lake feature ensures that concurrent writes to the same table do not corrupt data and that each transaction is applied in a serializable manner?

Which Delta Lake feature relies on statistics such as minimum and maximum values to reduce the number of files scanned during a query?

Keep studying — Data Modeling