Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional Exam - Question 32

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source tables has been de-duplicated and validated, which statement describes what will occur when this code is executed?

A batch job will update the enriched_itemized_orders_by_account table, replacing only those rows that have different values than the current version of the table, using accountID as the primary key.

The enriched_itemized_orders_by_account table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.

An incremental job will leverage information in the state store to identify unjoined rows in the source tables and write these rows to the enriched_iteinized_orders_by_account table.

An incremental job will detect if new rows have been written to any of the source tables; if new rows are detected, all results will be recalculated and used to overwrite the enriched_itemized_orders_by_account table.

No computation will occur until enriched_itemized_orders_by_account is queried; upon query materialization, results will be calculated using the current valid version of data in each of the three tables referenced in the join logic.

Show Answer

Correct Answer: B

This code reads data from three source tables, joins them, and then writes the result to the 'enriched_itemized_orders_by_account' table using the '.mode("overwrite")' method. The '.mode("overwrite")' indicates that the existing table will be completely replaced with the new data generated from the current values in the source tables. Thus, the entire 'enriched_itemized_orders_by_account' table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.

Discussion

4 comments

sturcuOption: B

Oct 16, 2023

B is correct

Jay_98_11Option: B

Jan 13, 2024

correct

AziLaOption: B

Jan 28, 2024

Correct Ans is B

imatheushenriqueOption: B

Jun 4, 2024

B is correct