COF-R02 Exam Questions

What can be used to view warehouse usage over time? (Select Two).

Which Snowflake feature is used for both querying and restoring data?

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi- Factor Authentication (MFA) service to provide increased login security for users con...

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

What tasks can be completed using the copy command? (Select TWO)

What feature can be used to reorganize a very large table on one or more columns?

What SQL command would be used to view all roles that were granted to user.1?

Which of the following can be executed/called with Snowpipe?

What Snowflake role must be granted for a user to create and manage accounts?

When unloading to a stage, which of the following is a recommended practice or approach?

When is the result set cache no longer available? (Select TWO)

Which of the following describes external functions in Snowflake?

What are ways to create and manage data shares in Snowflake? (Select TWO)

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return th...

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

What is the purpose of an External Function?

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

What is the purpose of multi-cluster virtual warehouses?

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Which command sets the Virtual Warehouse for a session?

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

True or False: Snowpipe via REST API can only reference External Stages as source.

Which of the following are best practices for loading data into Snowflake? (Choose three.)

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

What is the minimum Snowflake edition that has column-level security enabled?

When cloning a database, what is cloned with the database? (Choose two.)

Which of the following describes the Snowflake Cloud Services layer?

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

What type of query benefits the MOST from search optimization?

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Which of the following is a data tokenization integration partner?

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

What are supported file formats for unloading data from Snowflake? (Choose three.)

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it...

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

How long is the Fail-safe period for temporary and transient tables?

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

How does Snowflake Fail-safe protect data in a permanent table?

A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_r...

Which minimum Snowflake edition allows for a dedicated metadata store?