COF-C03 Question 197
Single answerData lineageA data engineering team loads raw customer records into a staging table, transforms them into a curated table, and then publishes a secure view for analysts. During an audit, the team must quickly identify which upstream objects contributed to the data shown in the secure view and which downstream objects depend on the curated table. Which Snowflake feature should the team use to investigate these object relationships most directly?
- A
Use Snowflake data lineage to trace upstream and downstream object relationships across tables and views
- B
Use Time Travel on the secure view to list all source objects that contributed to the current result set
- C
Use Fail-safe to determine which tables and views were used to build dependent objects
- D
Use the search optimization service to discover dependency paths between the staging table, curated table, and secure view
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Snowflake data lineage. For audit, impact analysis, and root-cause investigation, data lineage helps identify upstream sources that feed an object and downstream objects that depend on it. This is especially useful in pipelines involving staging tables, transformed tables, and published views. In contrast, Time Travel and Fail-safe are data recovery features, and search optimization service is a performance feature. Snowflake documentation and product guidance distinguish lineage as the feature for understanding object relationships and data flow, which is exactly what this scenario requires.
- A. Correct.
Correct. Snowflake data lineage is designed to help users understand how data flows between Snowflake objects, including upstream sources and downstream dependents. In this scenario, the audit requires visibility into which objects contributed to the secure view and what depends on the curated table. Data lineage is the most direct feature for tracing these relationships.
- B. Incorrect.
Incorrect. Time Travel allows access to historical data versions for supported objects within the retention period, but it does not provide dependency mapping or object lineage. A user might choose this option because audits often involve historical investigation, but Time Travel is for querying past states, not tracing source-to-target relationships.
- C. Incorrect.
Incorrect. Fail-safe is a disaster recovery mechanism that provides an additional recovery period after Time Travel expires. It is not intended for user-driven analysis and does not expose lineage or dependency information. This option reflects the misconception that all data recovery features also provide metadata analysis capabilities.
- D. Incorrect.
Incorrect. Search optimization service improves the performance of selective queries on large tables, especially for point lookups and certain predicate patterns. It does not map data flow or dependencies between Snowflake objects. This distractor is plausible because it involves metadata-driven optimization, but it is unrelated to lineage analysis.