Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 589

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

    Correct Answer: A

    Access history in Snowflake allows administrators to identify unused data by tracking read and write operations. This feature provides insights into which data is not frequently accessed, aiding decisions to archive or delete such data.

Discussion
MultiCloudIronManOption: A

Each row in the ACCESS_HISTORY view contains a single record per SQL statement. The record describes the columns the query accessed directly and indirectly (i.e. the underlying tables that the data for the query comes from). These records facilitate regulatory compliance auditing and provide insights on popular and frequently accessed tables and columns since there is a direct link between the user (i.e. query operator), the query, the table or view, the column, and the data

okurokOption: A

https://docs.snowflake.com/en/user-guide/access-history#:~:text=Discover%20unused%20data%20to%20determine%20whether%20to%20archive%20or%20delete%20the%20data.

muks86Option: A

https://docs.snowflake.com/en/user-guide/access-history

nexerSnowOption: A

Access history in Snowflake provides the following benefits pertaining to read and write operations: Data discovery: Discover unused data to determine whether to archive or delete the data. https://docs.snowflake.com/en/user-guide/access-history

MultiCloudIronManOption: A

Classification enables categorizing potentially personal and/or sensitive data stored in Snowflake to help organizations properly govern access to the data.

RenvisOption: A

Data classification is to classify personal data. it is a governance feature, https://docs.snowflake.com/en/user-guide/governance-classify. So answer should be A.