DatabricksDatabricks
CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #40
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
Data Modeling and Data Warehousing Concepts
Question
The view updates represents an incremental batch of all newly ingested data to be inserted or updated in the customers table. The following logic is used to process these records. Which statement describes this implementation?
Options
- AThe customers table is implemented as a Type 3 table; old values are maintained as a new
- BThe customers table is implemented as a Type 2 table; old values are maintained but marked as
- CThe customers table is implemented as a Type 0 table; all writes are append only with no
- DThe customers table is implemented as a Type 1 table; old values are overwritten by new values
- EThe customers table is implemented as a Type 2 table; old values are overwritten and new
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
#Slowly Changing Dimensions#Data Warehousing#Data Modeling#ETL/ELT Concepts