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

The query results cache can be used as long as the data in the table has not changed since the last time the query was run.If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query1.

Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed previously, all the given operations would require compute to execute.It's important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits2.

Snowpipe retains load history for 14 days.This allows users to view and audit the data that has been loaded into Snowflake using Snowpipe within this time frame3.

A row access policy can be applied to a table or a view within the policy DDL when defining the policy.Additionally, an existing row access policy can be applied to a table or a view using theALTER <object> ADD ROW ACCESS POLICY command

ThePUTcommand is used to load data files into a Snowflake stage.This command uploads data files from a local file system to a specified stage in Snowflake

In the Snowflake Data Marketplace, the types of data listings available include 'Vendor', which refers to the providers of data, and 'Personalized', which indicates customized data offerings tailored to specific consumer needs45.

The maximum Time Travel retention period for a temporary Snowflake table is 1 day.This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window

A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries.Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand

Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP).These platforms allow users to stage data externally and integrate with Snowflake for data loading operations