exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

Exam Certified Data Engineer Professional topic 1 question 211 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 211
Topic #: 1
[All Certified Data Engineer Professional Questions]

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?

  • A. The customers table is implemented as a Type 2 table; old values are overwritten and new customers are appended.
  • B. The customers table is implemented as a Type 2 table; old values are maintained but marked as no longer current and new values are inserted.
  • C. The customers table is implemented as a Type 0 table; all writes are append only with no changes to existing values.
  • D. The customers table is implemented as a Type 1 table; old values are overwritten by new values and no history is maintained.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
KadELbied
1 month, 2 weeks ago
Selected Answer: B
suretly B
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...