Databricks Certified Data Engineer - Professional

Explanation

Let's analyze each option:

A. Deletes cannot be processed at the same time as appends and updates. - ❌ False. In Databricks Delta Lake with CDF, deletes can be processed concurrently with appends and updates. The change data feed captures all types of changes (inserts, updates, deletes) and they can occur simultaneously.

B. Commit messages can be specified as part of the write options using the userMetadata option. - ✅ True. The userMetadata option allows you to add custom commit messages that are recorded in the transaction log, which is useful for tracking changes in CDF.

C. Deleting data will create new data files rather than deleting existing data files. - ✅ True. In Delta Lake, deletes are implemented as soft deletes - they create new data files with the remaining records rather than physically deleting existing data files. This maintains data integrity and enables time travel.

D. In order to propagate deletes to a table, a MERGE statement is required in SQL. - ❌ False. Deletes can be propagated using standard DELETE statements in SQL, not just MERGE statements. MERGE is used for upsert operations but is not required for deletes.

Therefore, the correct answers are B and C.