COF-R02 Online Practice Questions and Answers

True or False: Snowflake charges a premium for storing semi-structured data.

A. True

B. False

Which of the following terms best describes Snowflake's database architecture?

A. Columnar shared nothing

B. Shared disk

C. Multi-cluster, shared data

D. Cloud-native shared memory

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A. Pipe

B. External stage

C. Task

D. Stream

Which of the following objects can be shared through secure data sharing?

A. Masking policy

B. Stored procedure

C. Task

D. External table

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

A. The table contains a column that has very low cardinality

B. DML statements that are being issued against the table are blocked

C. The table has a small number of micro-partitions

D. Queries on the table are running slower than expected

E. The clustering depth for the table is large

Which statement is true about running tasks in Snowflake?

A. A task can be called using a CALL statement to run a set of predefined SQL commands.

B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

C. A task allows a user to execute a set of SQL commands on a predefined schedule.

D. A task can be executed using a SELECT statement to run a predefined SQL command.

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B. The transient table version cannot be retrieved after 24 hours.

C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

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

A. The Data Consumer pays for data storage as well as for data computing.

B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C. A Snowflake account can both provide and consume shared data.

D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E. The Data Consumer pays only for compute resources to query the shared data.

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A. Cloud services layer

B. Compute layer

C. Storage layer

D. Cloud agnostic layer

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

A. Into single files with 100-250 MB of compressed data per file

B. Into single files with 1-100 MB of compressed data per file

C. Into files of maximum size of 1 GB of compressed data per file

D. Into files of maximum size of 4 GB of compressed data per file