COF-C02 Online Practice Questions and Answers

Snowflake is designed for which type of workloads? (Choose two.)

A. OLAP (Analytics) workloads

B. OLTP (Transactional) workloads

C. Concurrent workloads

D. On-premise workloads

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A. A Schema may contain one or more Databases

B. A Database may contain one or more Schemas

C. A Schema is a logical grouping of Database Objects

D. Each Schema is contained within a Warehouse

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A. 4

B. 16

C. 32

D. 128

Which of the following statement is true of Snowflake? Select one.

A. It was built specifically for the cloud

B. it was built as an on-premises solution and then potted to the cloud

C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D. It was built for Hadoop architecture

E. It's based on an Oracle Architecture

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

A. Materialized views

B. Sequences

C. Procedures

D. Tables

E. Secure User Defined Functions (UDFs)

What are the default Time Travel and Fail-safe retention periods for transient tables?

A. Time Travel-1 day. Fail-safe-1 day

B. Time Travel-0 days. Fail-safe-1 day

C. Time Travel-1 day. Fail-safe-0 days

D. Transient tables are retained in neither Fail-safe nor Time Travel

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

A. Files

B. External tables

C. Secure User-Defined Functions (UDFs)

D. Sequences

E. Streams

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

A. Search optimization service

B. Automatic clustering

C. Row access policies

D. Multi-cluster virtual warehouses

E. Secure views

How does a Snowflake user execute an anonymous block of code?

A. The user must run the CALL command to execute the block.

B. The statements that define the block must also execute the block.

C. The SUBMIT command must run immediately after the block is defined

D. The block must be saved to a worksheet and executed using a connector.

What is the name of the SnowSQL file that can store connection information?

A. history

B. config

C. snowsql.cnf

D. snowsql.pubkey

What action can a user take to address query concurrency issues?

A. Enable the search optimization service.

B. Enable the query acceleration service.

C. Add additional clusters to the virtual warehouse.

D. Resize the virtual warehouse to a larger instance size.

What is the MINIMUM configurable idle timeout value for a session policy in Snowflake?

A. 2 minutes

B. 5 minutes

C. 10 minutes

D. 15 minutes

Which command should be used to implement a masking policy that was already created in Snowflake?

A. ALTER MASKING POLICY

B. APPLY MASKING POLICY

C. CREATE MASKING POLICY

D. SET MASKING POLICY

A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.

Which file format option MUST be used to do this?

A. encoding

B. escape

C. file_extension

D. single

What can be used to process unstructured data?

A. External tables

B. The COPY INTO

C. External functions

D. Snowpipe