Passed Exam Today COF-C03

The correct answer is A. View.

In Snowflake, a SQL User-Defined Function can reference certain database objects in a SQL expression or query expression. A view can be referenced by a SQL UDF, subject to normal privilege and ownership rules.

Why A is correct:

A UDF can include SQL logic that references a view. This allows reusable logic to be built on top of existing query definitions.

Example concept:

CREATE FUNCTION my_function()

RETURNS NUMBER

AS

$$

SELECT COUNT(*) FROM my_view

$$;

Why the other options are less appropriate:

B. A stream is a change tracking object and is not the standard object referenced from a UDF for reusable query logic.

C. An external table is used to query data stored in external cloud storage. It is not the best answer for this SnowPro-style question.

D. A materialized view is a precomputed view-like object, but the standard documented answer for an object referenced from a UDF is a view.

Official Snowflake documentation reference:

Snowflake documentation for SQL UDFs explains that SQL UDF definitions can contain SQL expressions and query expressions. These query expressions can reference database objects such as views, depending on privileges and valid SQL usage.

The correct answer is C. To track how data has been transformed among columns .

Snowflake’s data lineage capability is used to understand how data flows and changes across objects. It helps users see relationships between source and target objects and understand how data is transformed, especially at the column level.

Corrected wording:

The original option said “records,” but Snowflake data lineage is more accurately described as tracking how data is transformed among columns, not individual row-level record transformations.

Why C is correct:

Data lineage helps track how data moves from source columns to target columns through operations such as views, CTAS statements, INSERT statements, and other transformations. This is useful for governance, impact analysis, auditing, and understanding downstream dependencies.

Why the other options are incorrect:

A. Tracking how records are read by a user is more closely related to access history or query history, not data lineage.

B. Tracking dependencies at the object level is related to object dependencies. Data lineage is more specific because it can show how data flows between columns and objects.

D. Snowflake data lineage is not primarily a row-level feature for tracking the impact of transformations on individual records.

Official Snowflake documentation reference:

Snowflake documentation describes data lineage as a governance capability that helps track how data moves and transforms across Snowflake objects, including column-level relationships.

The ORGADMIN role in Snowflake is responsible for managing organization-level administrative functions, which include managing billing and credit data. This role has the highest level of administrative privileges and can oversee multiple Snowflake accounts within an organization.

Snowflake Documentation: Account and Organization Roles