COF-R02 Online Practice Questions and Answers

True or False: Snowflake supports federated authentication in all editions.

A. True

B. False

When can a Virtual Warehouse start running queries?

A. 12am-5am

B. Only during administrator defined time slots

C. When its provisioning is complete

D. After replication

Which of the following roles is recommended to be used to create and manage users and roles?

A. SYSADMIN

B. SECURITYADMIN

C. PUBLIC

D. ACCOUNTADMIN

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A. True

B. False

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A. A single join node uses more than 50% of the query time

B. Partitions scanned is equal to partitions total

C. An AggregateOperacor node is present

D. The query is spilling to remote storage

Which statement about billing applies to Snowflake credits?

A. Credits are billed per-minute with a 60-minute minimum

B. Credits are used to pay for cloud data storage usage

C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D. Credits are consumed based on the warehouse size and the time the warehouse is running

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A. VARIANT

B. ARRAY

C. VARCHAR

D. XML

E. BLOB

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1.

Runs a query that takes 3 minutes to complete

2.

Leaves for 15 minutes

3.

Returns and runs a query that takes 10 seconds to complete

4.

Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

A. 4 minutes

B. 10 minutes

C. 14 minutes

D. 24 minutes

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

A. Schemas

B. Roles

C. Secure Views

D. Stored Procedures

E. Tables

F. Secure User-Defined Functions (UDFs)

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

A. 10-50 MB

B. 100-250 MB

C. 300-500 MB

D. 1000-1500 MB