Databricks Certified Data Engineer - Professional
Comments
Loading comments...
Ultimate access to all questions.
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?_
A
SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE change_type = 'INSERT';
B
SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE change_type in ('insert', 'delete');
C
SELECT customer_id, bill_date, amount FROM bills WHERE _change_type = 'INSERT';
D
SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE _change_type in ('insert', 'update_preimage');
E
SELECT customer_id, bill_date, amount FROM table_changes('bills', 0) WHERE change_type = 'insert';