Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Quick Answer

Answer-first summary for fast verification

Answer: ```sql SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE _change_type = 'insert';

The correct answer is option E. When Change Data Feed is enabled for a delta table, the `table_changes()` function can be used to access change data logs. To retrieve the initial bill details for all customers, you should query the `table_changes('bills', 0)` with a filter on `_change_type = 'insert'`, as this captures the first insertion of each customer's bill. This approach ensures you only get the original bill details without subsequent updates or deletions.

Author: LeetQuiz Editorial Team

Quick Answer

Answer-first summary for fast verification

Answer: ```sql SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE _change_type = 'insert';

Author: LeetQuiz Editorial Team

Comments (1)

46765 56754Jan 4, 2026 12:19 AM

wrong format italic change_type refers to " __change_type"

LeetQuiz .Jan 6, 2026 9:07 AM

Thanks for your feedback. I've updated the option. Based on the official document: https://docs.databricks.com/aws/en/delta/delta-change-data-feed#change-data-feed-schema, the correct column name is "_change_type" instead.

A broadband company uses a delta table named `bills` with Change Data Feed enabled to store the latest bills of all customers. The table is updated whenever a new bill is generated, with only the `bill_date` and `amount` columns being updated for existing customers. If a customer leaves the company, their bill details are deleted from the `bills` table. Which query should be used to retrieve the list of all customers along with the details of their first-ever bill?

Real Exam

SELECT customer_id,
bill_date,
amount
FROM table_changes('bills', 0)
WHERE _change_type = 'INSERT';

SELECT customer_id,
bill_date,
amount
FROM table_changes('bills', 0)
WHERE _change_type = 'INSERT';

17.0%

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type IN ('insert', 'delete');

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type IN ('insert', 'delete');

8.9%

SELECT customer_id, bill_date, amount
FROM bills
WHERE _change_type = 'INSERT';

SELECT customer_id, bill_date, amount
FROM bills
WHERE _change_type = 'INSERT';

11.9%

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type IN ('insert', 'update_preimage');

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type IN ('insert', 'update_preimage');

16.3%

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type = 'insert';

SELECT customer_id, bill_date, amount
FROM table_changes('bills', 0)
WHERE _change_type = 'insert';

45.9%