CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #28: Real Exam Question with Answer & Explanation

Question

A junior data engineer seeks to leverage Delta Lake's Change Data Feed functionality to create a Type 1 table representing all of the values that have ever been valid for all rows in a bronze table created with the property delta.enableChangeDataFeed = true. They plan to execute the following code as a daily job: Which statement describes the execution and results of running the above query multiple times?

Options

• AEach time the job is executed, newly updated records will be merged into the target table,
• BEach time the job is executed, the entire available history of inserted or updated records will be
• CEach time the job is executed, the target table will be overwritten using the entire history of
• DEach time the job is executed, the differences between the original and current versions are
• EEach time the job is executed, only those records that have been inserted or updated since the