Exam Certified Data Engineer Professional topic 1 question 218 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 218
Topic #: 1

[All Certified Data Engineer Professional Questions]

A user wants to use DLT expectations to validate that a derived table report contains all records from the source, included in the table validation_copy.

The user attempts and fails to accomplish this by adding an expectation to the report table definition.

Which approach would allow using DLT expectations to validate all expected records are present in this table?

A. Define a temporary table that performs a left outer join on validation_copy and report, and define an expectation that no report key values are null
B. Define a SQL UDF that performs a left outer join on two tables, and check if this returns null values for report key values in a DLT expectation for the report table
C. Define a view that performs a left outer join on validation_copy and report, and reference this view in DLT expectations for the report table
D. Define a function that performs a left outer join on validation_copy and report, and check against the result in a DLT expectation for the report table

Show Suggested Answer

Suggested Answer: A 🗳️

by benni_ale at Dec. 8, 2024, 6:41 p.m.

Comments

Submit Cancel

benni_ale

2 months ago

Selected Answer: A

Argubly a better solution would be Define a materialised view that performs a left outer join on validation_copy and report, and define an expectation that no report key values are null : https://docs.databricks.com/en/delta-live-tables/expectations.html?utm_source=chatgpt.com#perform-advanced-validation-with-delta-live-tables-expectations

upvoted 1 times

...

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

Comments

benni_ale

SY0-701