Practice COF-R02 Exam Online

Question 1

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)

Answer: A,D

Question 2

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

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Question 3

What happens to historical data when the retention period for an object ends?

A : The data is cloned into a historical object.

B : The data moves to Fail-safe

C : Time Travel on the historical data is dropped.

D : The object containing the historical data is dropped.

Answer: D

Question 4

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A : Schema Stage

B : User Stage

C : Database Stage

D : Table Stage

E : External Named Stage

F : Internal Named Stage

Answer: A

Question 5

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

A : The validation_mode option is used when creating an Internal Stage

B : validation_mode=return_all_errors is a parameter of the copy command

C : The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D : The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: D

Name:	SnowPro Core Recertification
Exam Code:	COF-R02
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	333
Last Updated:	Apr 24, 2024

Snowflake COF-R02