COF-R02 Online Practice Questions and Answers

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

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A. True

B. False

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

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Custom

B. Economy

C. Optimized

D. Standard

True or False: The COPY command must specify a File Format in order to execute.

A. True

B. False

Which command is used to unload data from a Snowflake table into a file in a stage?

A. COPY INTO

B. GET

C. WRITE

D. EXTRACT INTO

Which TABLE function helps to convert semi-structured data to a relational representation?

A. CHECK_JSON

B. TO_JSON

C. FLATTEN

D. PARSE_JSON

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

A. Compute

B. Data storage

C. Cloud services

D. Cloud provider

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A. Queries against large tables where frequent DML occurs

B. Queries against tables larger than 1 TB

C. Selective point lookup queries

D. Queries against a subset of columns in a table

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

A. UPDATE TABLE FROM STREAM

B. SELECT FROM STREAM

C. INSERT INTO TABLE SELECT FROM STREAM

D. ALTER TABLE AS SELECT FROM STREAM

E. BEGIN COMMIT