nerdexam
DatabricksDatabricks

CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #73

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

Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.

Data Transformation and Processing

Question

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?

Options

  • AThe silver_customer_sales table will be overwritten by aggregated values calculated from all
  • BA batch job will update the gold_customer_lifetime_sales_summary table, replacing only those
  • CThe gold_customer_lifetime_sales_summary table will be overwritten by aggregated values
  • DAn incremental job will leverage running information in the state store to update aggregate values
  • EAn incremental job will detect if new rows have been written to the silver_customer_sales table; if

Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer

You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data Lakehouse Architecture#Batch Data Processing#Data Aggregation#Table Overwrite Operations
Full CERTIFIED-DATA-ENGINEER-PROFESSIONAL PracticeBrowse All CERTIFIED-DATA-ENGINEER-PROFESSIONAL Questions