Which technique is commonly used to make streaming writes idempotent?

Using a unique identifier column for deduplication

Using the 'overwrite' output mode

What is a key benefit of using a single Delta table for both batch and streaming ingestion?

It requires no checkpointing for streaming writes

It automatically converts streaming data to batch format

It provides a unified view of data with ACID guarantees

It eliminates the need for schema enforcement

A streaming query writes to a Delta table and uses a checkpoint directory on DBFS. The team wants to monitor the progress of the stream and ensure it can recover from failures. Which action should be taken?

Use the 'DeltaTable' API to monitor the stream.

Set the checkpoint location to a temporary directory to avoid clutter.

Use the 'StreamingQueryListener' to track progress and ensure the checkpoint directory is on a reliable storage location.

Disable checkpointing to improve performance.

DatabricksCertified Data Engineer Professional

Domain 2Objective 2

Create an Append-Only Data Pipeline Capable of Handling Both Batch and Streaming Data Using Delta. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

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

24questions here

5free pages

8concepts

7%of the exam

Questions 21–24

21foundation · easy
Which technique is commonly used to make streaming writes idempotent?
Select an answer first
22foundation · easy
What is a key benefit of using a single Delta table for both batch and streaming ingestion?
Select an answer first
23application · medium
A streaming query writes to a Delta table and uses a checkpoint directory on DBFS. The team wants to monitor the progress of the stream and ensure it can recover from failures. Which action should be taken?
Select an answer first
24foundation · easy
Which Delta table property enforces that only append operations are allowed?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

Create an Append-Only Data Pipeline Capable of Handling Both Batch and Streaming Data Using Delta. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

Questions 21–24

Which technique is commonly used to make streaming writes idempotent?

What is a key benefit of using a single Delta table for both batch and streaming ingestion?

A streaming query writes to a Delta table and uses a checkpoint directory on DBFS. The team wants to monitor the progress of the stream and ensure it can recover from failures. Which action should be taken?

Which Delta table property enforces that only append operations are allowed?

Keep studying — Data Ingestion & Acquisition