Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

The correct answer is A. Access history. Access History in Snowflake records when database objects (tables, views, columns) were last read or written. By querying the ACCESS_HISTORY view in the ACCOUNT_USAGE schema, administrators can identify tables or columns that have not been accessed for an extended period…

Data Governance

Question

Options

AAccess history
BData classification
CDynamic Data Masking
DObject tagging

How the community answered

(19 responses)

A
89% (17)
B
5% (1)
C
5% (1)

Explanation

Access History in Snowflake records when database objects (tables, views, columns) were last read or written. By querying the ACCESS_HISTORY view in the ACCOUNT_USAGE schema, administrators can identify tables or columns that have not been accessed for an extended period, making them candidates for archival or deletion. Data classification (B) labels sensitive data by type. Dynamic Data Masking (C) obscures column values at query time. Object tagging (D) attaches metadata labels to objects but does not inherently track access timestamps.

Topics

#Access History#Data Usage Monitoring#Data Lifecycle Management#Cost Optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice