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

The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D).Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.

In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.

In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A).This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it2.

The SQL commandSelect * from table(validate(t1, job_id => '_last'));is used to return errors from the last executed COPY command into table t1 in the current session.It checks the results of the most recent data load operation and provides details on any errors that occurred during that process1.

Snowflake supports unloading data in JSON and delimited file formats such as CSV and TSV.These formats are commonly used for data interchange and are supported by Snowflake for unloading operations

The Snowflake Search Optimization Service is designed to support improved performance for selective point lookup queries.These are queries that retrieve specific records from a database, often based on a unique identifier or a small set of criteria3.

The Query Profile in Snowflake is used to identify performance issues with queries. Common issues that can be found using the Query Profile include identifying inefficient micro-partition pruning (D) and data spilling to a local or remote disk (E).Micro-partition pruning is related to the efficiency of query execution, and data spilling occurs when the memory is insufficient, causing the query to write data to disk, which can slow down the query performance1.

When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped .This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.

By default, the Snowflake role required to create a share is ACCOUNTADMIN (D).This role has the necessary privileges to perform administrative tasks, including creating shares for data sharing purposes