COF-C02 Question #529: Real Exam Question with Answer & Explanation

The correct answer is A: ACCESS_HISTORY. In Snowflake, the system-defined, read-only view that displays information on column lineage, which specifies how data flows from source to target in a SQL write operation, is ACCESS_HISTORY. This view is instrumental in auditing and analyzing data access patterns, as it provides

Data Governance

Question

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

Options

AACCESS_HISTORY
BLOAD_HOSTORY
CQUERY_HISTORY
DCOPY_HISTORY

Explanation

In Snowflake, the system-defined, read-only view that displays information on column lineage, which specifies how data flows from source to target in a SQL write operation, is ACCESS_HISTORY. This view is instrumental in auditing and analyzing data access patterns, as it provides detailed insights into how and from where the data is being accessed and manipulated within Snowflake.

Topics

#Column Lineage#ACCESS_HISTORY View#Data Governance#System Views

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions