Exam Certified Data Engineer Professional topic 1 question 204 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 204
Topic #: 1

[All Certified Data Engineer Professional Questions]

The data engineering team maintains the following code:

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

A. The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.
B. A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.
C. The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.
D. An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.

Show Suggested Answer

Suggested Answer: C 🗳️

by _lene_ at Jan. 14, 2025, 2:16 p.m.

Comments

Submit Cancel

KadELbied

3 months ago

Selected Answer: C

suretly C

upvoted 1 times

...