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

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

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:



A batch job is attempting to insert new records to the table, including a record where latitude = 45.50 and longitude = 212.67.

Which statement describes the outcome of this batch insert?

  • A. The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.
  • B. The write will fail completely because of the constraint violation and no records will be inserted into the target table.
  • C. The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.
  • D. The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.
  • E. The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by PearApple at Oct. 21, 2023, 8:07 p.m.

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
Submit Cancel
vctrhugo
Highly Voted 9 months, 3 weeks ago
Selected Answer: B
In Delta Lake, when a batch job attempts to insert records into a table that has a CHECK constraint, if any record violates the constraint, the entire write operation fails. This is because Delta Lake enforces strong transactional guarantees, which means that either all changes in a transaction are saved, or none are.
upvoted 5 times
...
spaceexplorer
Most Recent 10 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
aragorn_brego
1 year ago
Selected Answer: B
In systems that support atomic transactions, such as Delta Lake, when a batch operation encounters a record that violates a CHECK constraint, the entire operation fails, and no records are inserted, including those that do not violate the constraint. This is to ensure the atomicity of the transaction, meaning that either all the changes are committed, or none are, maintaining data integrity. The record with a longitude of 212.67 violates the constraint because longitude values must be between -180 and 180 degrees.
upvoted 4 times
...
Dileepvikram
1 year ago
B is the answer
upvoted 4 times
...
sturcu
1 year, 1 month ago
Selected Answer: B
B is the answer
upvoted 4 times
...
PearApple
1 year, 1 month ago
B is the ans
upvoted 3 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