COF-R02 Exam Questions

Network policies can be set at which Snowflake levels? (Choose two.)

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Which of the following objects are contained within a schema? (Choose two.)

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The fol...

Which of the following describes a Snowflake stored procedure?

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

How are serverless features billed?

Which Snowflake architectural layer is responsible for a query execution plan?

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

What is the default file size when unloading data from Snowflake using the COPY command?

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Which Snowflake layer is always leveraged when accessing a query from the result cache?

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can th...

Users are responsible for data storage costs until what occurs?

What affects whether the query results cache can be used?

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

How many days is load history for Snowpipe retained?

How can a row access policy be applied to a table or a view? (Choose two.)

Which command can be used to load data files into a Snowflake stage?

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

What is the maximum Time Travel retention period for a temporary Snowflake table?

When should a multi-cluster warehouse be used in auto-scaling mode?

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

In the Snowflake access control model, which entity owns an object by default?

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will...

A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

What is true about sharing data in Snowflake? (Choose two.)

The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON. How can this be accomplished?

Which of the following significantly improves the performance of selective point lookup queries on a table?

Which of the following accurately describes shares?

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

What is the minimum Snowflake edition required for row level security?

The is the minimum Fail-safe retention time period for transient tables?

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

What COPY INTO SQL command should be used to unload data into multiple files?

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

When loading data into Snowflake, how should the data be organized?

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?