Snowflake Updated COF-C02 Exam Questions and Answers by ellie-mae

 The Access History feature in Snowflake allows administrators to track data access patterns and identify unused data. This information can be used to make decisions about archiving or deleting data to optimize storage and reduce costs. 

When a tag object is assigned to a table, using the statement CREATE TABLE AS SELECT * FROM TABLE_A will automatically assign the TABLE_A tag to the newly created table2.

Snowflake stores metadata for rows in micro-partitions, including the range of values for each column and the number of distinct values1.

 A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.