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?

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…

Data Governance

Question

Options

AACCESS_HISTORY
BLOAD_HOSTORY
CQUERY_HISTORY
DCOPY_HISTORY

How the community answered

(32 responses)

A
91% (29)
C
6% (2)
D
3% (1)

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