Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which method enables the use of DLT expectations to verify that a derived table report includes all records from the source table validation_copy?
validation_copy
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
