Question 190
An engineering group maintains code-defined Lakeflow pipelines for distinct business datasets. After configuring Refactor the logic into a reusable function or private intermediate dataset as supported, the engineer must validate: A pipeline needs a reused intermediate subquery with no persisted public table. What evidence is decisive?
Explanation
Correct Answer
The pipeline produces the correct downstream outputs without an unintended published table directly measures whether Refactor the logic into a reusable function or private intermediate dataset as supported achieved the requirement “A pipeline needs a reused intermediate subquery with no persisted public table.” It checks the operating result rather than just a configured resource name.
Incorrect Answers
The pipeline discovers new files and commits them without a daily full scan pertains to a different control (Use the Auto Loader `cloudFiles` streaming source in a pipeline dataset) and a different need (A pipeline must ingest a stream from supported cloud files with Auto Loader). It cannot establish that Refactor the logic into a reusable function or private intermediate dataset as supported met the stated goal.
A newer change event updates only the matching key according to sequence would demonstrate the separate action Define the required target and AUTO CDC flow with `keys` and `sequence_by`, which addresses “An AUTO CDC flow should be configured against a target with stable natural keys.” It does not verify the requirement “A pipeline needs a reused intermediate subquery with no persisted public table” following Refactor the logic into a reusable function or private intermediate dataset as supported.
The pipeline DAG contains the materialized view and its dataset is refreshed pertains to a different control (Use the supported pipelines Python decorator for a materialized view function) and a different need (A Python pipeline definition should register a managed materialized view with declarative SQL). It cannot establish that Refactor the logic into a reusable function or private intermediate dataset as supported met the stated goal.