Question 90
A pipeline needs three transforms executed in dependency order rather than independent schedules that race. The team proposes this action: Create a task graph using supported predecessor relationships for the transformation stages. Why should that action address the stated requirement?
Explanation
Correct Answer
Task dependencies coordinate the order of downstream work after upstream task completion. This explains the proposed action: create a task graph using supported predecessor relationships for the transformation stages.
Incorrect Answers
COPY options such as ON_ERROR influence whether a failed record or file halts or skips loading. That rationale explains choose a supported COPY error-handling strategy based on an explicit acceptance policy. It does not establish the mechanism needed here: task dependencies coordinate the order of downstream work after upstream task completion.
Storage integrations decouple cloud authorization configuration from direct embedded credentials. That rationale explains use a Snowflake storage integration with the cloud provider's authorized identity and location scope. It does not establish the mechanism needed here: task dependencies coordinate the order of downstream work after upstream task completion.
Directory tables expose file metadata for staged unstructured data workflows. That rationale explains use supported stages and directory-table metadata where the unstructured-file use case calls for it. It does not establish the mechanism needed here: task dependencies coordinate the order of downstream work after upstream task completion.





SnowPro Core COF-C03 Practice Tests