Free Snowflake COF-C02 Practice Exam with Questions & Answers | Set: 3

The Cloud Services layer in Snowflake is responsible for managing the result cache. When a query is executed, the results are stored in this cache, and subsequent identical queries can leverage these cached results without re-executing the entire query1.

 Best practices for loading data into Snowflake include aiming for data file sizes between 100 MB and 250 MB when compressed, as this size is optimal for parallel processing and minimizes overhead. Enclosing fields with delimiter characters in quotes ensures proper field recognition during the load process. Splitting large files into smaller ones allows for better distribution of the load across compute resources, enhancing performance and efficiency.

When a running virtual warehouse in Snowflake issuspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.

The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creatingand maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table

Column-level security, which allows for the application of masking policies to columns in tables or views, is available starting from the Enterprise edition of Snowflake1.

References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1

The responsibilities of Snowflake’s Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3.

Worksheets in Snowsight can be shared directly with other Snowflake users within the same account. This feature allows for collaboration and sharing of SQL queries or Python code, as well as other data manipulation tasks1.

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.

Shares in Snowflake are named objects that encapsulate all the information required to share databases, schemas, tables, secure views, and secure UDFs. These objects can be added to a share by granting privileges on them to the share via a database role

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.

The correct answer is D. ON_ERROR = ABORT_STATEMENT .

ON_ERROR = ABORT_STATEMENT stops the load operation if an error is encountered. This helps avoid loading only part of a dataset when a file or row error occurs.

Why D is correct:

If the goal is to avoid a partial dataset, the load should fail rather than continue after errors. ABORT_STATEMENT prevents Snowflake from loading only the valid rows while skipping invalid ones.

Why the other options are incorrect:

A. FORCE = FALSE prevents reloading files that were already loaded, but it does not prevent partial loads caused by data errors.

B. RETURN_FAILED_ONLY affects command output reporting. It does not control whether partial data is loaded.

C. LOAD_UNCERTAIN_FILES = FALSE controls loading files with uncertain load status, but it is not the primary parameter for avoiding partial datasets caused by load errors.

D. ON_ERROR = ABORT_STATEMENT is the correct parameter because it stops the load when an error occurs.

Official Snowflake documentation reference:

Snowflake documentation for COPY INTO < table > describes ON_ERROR = ABORT_STATEMENT as the option that aborts the load operation when an error is encountered.