Snowflake SnowPro Core Practice Test - Questions Answers, Page 25

The bulk data load history available after a COPY statement is stored in the metadata of the pipe and is retained for 64 days1.

In the Information Schema and Account Usage, the column that identifies whether a view is secure or not isIS_SECURE2.

Snowflake's documentation recommends producing the largest files possible for data loading, as larger files reduce the number of files to process and the overhead associated with handling many small files.This approach can maximize the load performance by leveraging Snowflake's ability to ingest large files efficiently1.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

When deciding on a clustering key for a table, Snowflake recommends using the columns that are most actively used in the select filters.This is because clustering by these columns can improve the performance of queries that filter on these values, leading to more efficient scans and better overall query performance2.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher.This feature is part of Snowflake's comprehensive approach to encryption key management, ensuring data security through regular rekeying1.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege.This privilege allows the user to manage access control through grants on all securable objects within Snowflake2.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E).This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex

To allow secure views the ability to reference data in multiple databases, the REFERENCE_USAGE privilege must be granted on each database that contains objects referenced by the secure view2. This privilege is necessary before granting the SELECT privilege on a secure view to a share.

Automatic Clustering is a feature that allows users to control the organization of data within micro-partitions in Snowflake.By defining clustering keys, Snowflake can automatically reorganize the data in micro-partitions to optimize query performance1.