AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: To store the latest bills of all the databricks video

Question 1
« Back   Next data-engineer-professional Question »

Full Certification Question

To store the latest bills of all the customers, a broadband company uses a delta table named bills with Change Data Feed enabled. Whenever a bill is generated for a customer for the first time, the bill details are added to the table. Afterward, each time a new bill is generated for a customer, only the bill_date and amount columns are updated. If a customer parts ways with the company, the bill details are deleted from the bills table. Which of the following queries should be used to get the list of all the customers with details of their first-ever bill?