What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

The correct answer is C. ACCESS_HISTORY. The ACCESS_HISTORY (C) view in the SNOWFLAKE.ACCOUNT_USAGE schema tracks which Snowflake objects (tables, views, columns, stages, etc.) were accessed - read or written - by queries over the past 365 days. It is critical for data governance, compliance auditing, and…

Data Governance

Question

Options

AVIEWS_HISTORY
BOBJECT_HISTORY
CACCESS_HISTORY
DLOGIN_HISTORY

How the community answered

(23 responses)

B
4% (1)
C
91% (21)
D
4% (1)

Explanation

The ACCESS_HISTORY (C) view in the SNOWFLAKE.ACCOUNT_USAGE schema tracks which Snowflake objects (tables, views, columns, stages, etc.) were accessed - read or written - by queries over the past 365 days. It is critical for data governance, compliance auditing, and understanding data lineage. VIEWS_HISTORY (A) is not a standard ACCOUNT_USAGE view. OBJECT_HISTORY (B) is not a real view in this schema. LOGIN_HISTORY (D) is a real view but tracks user login attempts and authentication events, not object access by queries. ACCESS_HISTORY is the correct answer for tracking object-level query access.

Topics

#ACCOUNT_USAGE views#ACCESS_HISTORY#Data governance#Auditing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice