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 130 discussion

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

The following table consists of items found in user carts within an e-commerce website.



The following MERGE statement is used to update this table using an updates view, with schema evolution enabled on this table.



How would the following update be handled?

  • A. The update throws an error because changes to existing columns in the target schema are not supported.
  • B. The new nested Field is added to the target schema, and dynamically read as NULL for existing unmatched records.
  • C. The update is moved to a separate "rescued" column because it is missing a column expected in the target schema.
  • D. The new nested field is added to the target schema, and files underlying existing records are updated to include NULL values for the new field.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by MDWPartners at May 29, 2024, 6:55 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
pppppppppie
2 months, 3 weeks ago
because B says for unmatched records. but my new records has 1001 which is existing record. we should give ans what will happen with this new record. it will update the record in target with NULL as coupon
upvoted 1 times
...
pppppppppie
2 months, 3 weeks ago
It has to be D
upvoted 1 times
...
Freyr
5 months, 3 weeks ago
Selected Answer: B
Correct Answer: B. In the question it is mentioned that the schema evolution is enabled. This option states that the new nested field is added to the target schema, and existing records not matching the new schema format are populated with NULL for the newly added columns. This behavior aligns with how schema evolution functions in Delta Lake, dynamically adapting the schema to include new fields.
upvoted 3 times
...
MDWPartners
5 months, 4 weeks ago
Selected Answer: B
schema evolution is enabled, so B.
upvoted 4 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