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

Snowflake maintains a result cache that stores the results of every query for 24 hours.If the same query is executed again within this time frame and the data has not changed, Snowflake will retrieve the data from the result cache instead of using a virtual warehouse to recompute the results2.

A Snowflake Data Exchange allows groups of accounts to share data privately among the accounts (B), and it supports bidirectional sharing, meaning an account can be both a provider and a consumer of data (E).This facilitates secure and governed data collaboration within a selected group3.

Snowflake's secure data sharing feature allows sharing of certain database objects with other Snowflake accounts.Among the options provided, external tables and secure UDFs can be shared

Query parsing and compilation in Snowflake occur within the cloud services layer.This layer is responsible for various management tasks, including query compilation and optimization

The Snowflake Account_Usage.Metering_History view is used to gather the hourly credit usage for an account.This view provides details on the credits consumed by various services within Snowflake for the last 365 days1.

The SQL command GET_DDL can be used to retrieve the CREATE definition of a masking policy in Snowflake.This command generates the DDL statement required to recreate the masking policy

Pruning in Snowflake refers to the process of filtering or disregarding micro-partitions that are not needed to satisfy the conditions of a query.This optimization technique helps reduce the amount of data scanned, thereby improving query performance

In Snowflake, to change the columns referenced in a view, the view must be recreated with the required changes. TheALTER VIEWcommand does not allow changing the definition of a view; it can only be used to rename a view, convert it to or from a secure view, or add, overwrite, or remove a comment for a view.Therefore, the correct approach is to drop the existing view and create a new one with the desired column references.

To grant a role the privilege to select data from all current and future tables in a schema, two separate commands are needed.The first command grants theSELECTprivilege on all existing tables within the schema, and the second command grants theSELECTprivilege on all tables that will be created in the future within the same schema.