What is the passing score for the Snowflake SnowPro Core exam?

The SnowPro Core (COF-C03) certification exam passing score is 750 or higher on a scaled score range of 0 to 1000.

Is CloudPrep affiliated with Snowflake Inc.?

No. Snowflake® and SnowPro® are registered trademarks of Snowflake Inc. CloudPrep is an independent educational platform and is not affiliated with, sponsored by, or endorsed by Snowflake Inc.

Which view in `SNOWFLAKE.ACCOUNT_USAGE` records column-level read and write access for data lineage and compliance auditing?

`ACCESS_HISTORY` — `SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY` tracks column-level read and write access, capturing direct and indirect data lineage.

Which view in `ACCOUNT_USAGE` shows relationships between referencing objects (e.g. Views) and referenced objects (e.g. base Tables)?

`OBJECT_DEPENDENCIES` — `OBJECT_DEPENDENCIES` captures object-level relationships between views, tables, UDFs, and stages.

When an ETL query executes `INSERT INTO target_t (col_a) SELECT col_b FROM source_t;`, how does `ACCESS_HISTORY` record this?

It records `source_t.col_b` in `base_objects_accessed` and `target_t.col_a` in `objects_modified`, mapping direct column lineage. — `ACCESS_HISTORY` includes `objects_modified` and `direct_objects_accessed` arrays with column-level JSON arrays detailing source-to-target flow.

Domain: Account Management & Governance (Pro Study Module)

September 2026 · 698 words · 10 min read

Data Lineage

Overview

Understanding the flow of data—where it originates, how it transforms, and where it is consumed—is critical for modern data governance. In Snowflake, Data Lineage capabilities allow organizations to track data movement, perform impact analysis, ensure regulatory compliance, and troubleshoot data pipelines. For the SnowPro Core (COF-C03) exam, you must understand the views and mechanisms Snowflake provides for tracking lineage.

*Note: Advanced lineage features often require Snowflake Enterprise Edition or higher.*

Key Concepts

1. What is Data Lineage?

Unlock Full Deep-Dive Guide & 14 Practice MCQs

This complete architectural module, full checkpoint quiz, and unlimited mock exam simulations are included with the CloudPrep Pro Pass.

Unlock with Pro Pass