CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #91: Real Exam Question with Answer & Explanation

Question

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?

Options

• ADefine a SQL UDF that performs a left outer join on two tables, and check if this returns null
• BDefine a function that performs a left outer join on validation_copy and report and report, and
• CDefine a temporary table that perform a left outer join on validation_copy and report, and define
• DDefine a view that performs a left outer join on validation_copy and report, and reference this view