Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

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

Exam Certified Data Engineer Professional topic 1 question 40 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 40
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 3 table; old values are maintained as a new column alongside the current value.
  • 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.
  • E. The customers table is implemented as a Type 2 table; old values are overwritten and new customers are appended.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by chokthewa at Oct. 23, 2023, 7:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Tayari
4 weeks ago
B is correct
upvoted 1 times
...
imatheushenrique
5 months, 3 weeks ago
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. A Type 1 table does not track changes in dimensional attributes - the new value overwrites the existing value. Here, we do not preserve historical changes in data. A Type 2 Table tracks change over time by creating new rows for each change. A new dimension record is inserted with a high-end date or one with NULL. The previous record is "closed" with an end date. This approach maintains a complete history of changes and allows for as-was reporting use cases. A data warehousing method called Slowly Changing Dimension (SCD) Type 3 is used to track both the old and new values while managing historical changes in data over time. To reflect the historical and present values of an attribute, SCD Type 3 keeps two extra columns in the dimension table.
upvoted 2 times
...
spaceexplorer
10 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
kz_data
10 months, 2 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
chokthewa
1 year, 1 month ago
B is correct.
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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