A company maintains a `customers` table in Unity Catalog. A nightly feed provides `customer_updates` with columns `customer_id`, `name`, `email`, and `updated_at`. The `customers` table has a `last_updated` column. The feed contains both new customers and updates to existing customers. Some rows in the feed have NULL `email`. The requirement is to update only if the feed's `updated_at` is newer than the table's `last_updated`, and to insert new customers. What should you do?

Use MERGE with `WHEN MATCHED THEN UPDATE SET * WHEN NOT MATCHED THEN INSERT *` without a timestamp condition.

Use INSERT OVERWRITE with the feed data.

Use MERGE with a condition `WHEN MATCHED AND src.updated_at > target.last_updated THEN UPDATE SET * WHEN NOT MATCHED THEN INSERT *`.

Use UPDATE with a JOIN on customer_id, then INSERT for new customers.

A company collects IoT sensor readings throughout the day. Each reading has a unique `reading_id` and a `timestamp`. The team wants to add new readings to an existing Unity Catalog table without modifying or removing existing rows. Which operation should you use?

INSERT OVERWRITE with the new readings.

UNION the new readings with the existing table and overwrite.

INSERT INTO the table with the new readings.

MERGE with a match on reading_id to update existing rows.

A company has a Unity Catalog table `products` with columns `product_id`, `name`, `price`. A new product needs to be added. The `product_id` is auto-generated by the source system and is guaranteed unique. What is the simplest way to add the new product to the table?

Use `UPDATE` to add the new product.

Use `MERGE` with a match on product_id to insert the new product.

Use `INSERT INTO products (product_id, name, price) VALUES (101, 'New Product', 9.99)`

Use `APPEND` to add the new product.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 3Objective 3

Cleanse, Transform, and Load Data into Unity Catalog DP-750 Practice Questions (Page 3)

Part of the Prepare and process data domain, which accounts for 30–35% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~15–28 in this domain), expect 4–7 from this objective — we provide 20 practice questions to prepare you well beyond it. (estimate)

20questions here

4free pages

18concepts

30–35%of the exam

Questions 11–15

11application · medium
A company has two tables in Unity Catalog: `current_employees` and `former_employees`, both with columns `employee_id` and `name`. The HR team wants to identify employees who appear in both tables, possibly due to rehires, to review their records. Which operation should you use?
Select an answer first
12expert · hard
A company maintains a `customers` table in Unity Catalog. A nightly feed provides `customer_updates` with columns `customer_id`, `name`, `email`, and `updated_at`. The `customers` table has a `last_updated` column. The feed contains both new customers and updates to existing customers. Some rows in the feed have NULL `email`. The requirement is to update only if the feed's `updated_at` is newer than the table's `last_updated`, and to insert new customers. What should you do?
Select an answer first
13application · medium
A company collects IoT sensor readings throughout the day. Each reading has a unique `reading_id` and a `timestamp`. The team wants to add new readings to an existing Unity Catalog table without modifying or removing existing rows. Which operation should you use?
Select an answer first
14foundation · medium
In a data transformation pipeline, which operation is used to select rows from a DataFrame based on a condition?
Select an answer first
15application · medium
A company has a Unity Catalog table `products` with columns `product_id`, `name`, `price`. A new product needs to be added. The `product_id` is auto-generated by the source system and is guaranteed unique. What is the simplest way to add the new product to the table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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 Microsoft. “DP-750” is a trademark of its owner, used for identification only.

Cleanse, Transform, and Load Data into Unity Catalog DP-750 Practice Questions (Page 3)

Questions 11–15

A company has two tables in Unity Catalog: `current_employees` and `former_employees`, both with columns `employee_id` and `name`. The HR team wants to identify employees who appear in both tables, possibly due to rehires, to review their records. Which operation should you use?

A company collects IoT sensor readings throughout the day. Each reading has a unique `reading_id` and a `timestamp`. The team wants to add new readings to an existing Unity Catalog table without modifying or removing existing rows. Which operation should you use?

In a data transformation pipeline, which operation is used to select rows from a DataFrame based on a condition?

A company has a Unity Catalog table `products` with columns `product_id`, `name`, `price`. A new product needs to be added. The `product_id` is auto-generated by the source system and is guaranteed unique. What is the simplest way to add the new product to the table?

Keep studying — Prepare and process data