Snowflake COF-C02 Practice Test - Questions Answers, Page 24

To show all privileges granted to a specific schema, the commandSHOW GRANTS ON SCHEMA <schema_name>should be used3. In this case, it would beSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. References: [COF-C02] SnowPro Core Certification Exam Study Guide

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.References:[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.References:[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.References:[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.References:[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.