Question 1

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Options :

A : Roles

B : Databases

C : Warehouses

D : Users

E : Accounts

Answer: A,D

Question 2

Which of the following statements are true of Snowflake releases: (Choose two.)

Options :

A : They happen approximately weekly

B : They roll up and release approximately monthly, but customers can request early release application

C :

During a release, new customer requests/queries/connections transparently move over to the newer

version

D :

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which

the

system will be unavailable and customer is upgraded

Answer: A,C

Question 3

What happens when a virtual warehouse is resized?

Options :

A : When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B : When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C : The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D : Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Question 4

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

Options :

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Question 5

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

Options :

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

Higher Test Marks with Free Online COF-R02 Exam Practice

Buying Options: