Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

AAmazon Web Services

BDocker

CIBM Cloud

DMicrosoft Azure Cloud

EGoogle Cloud Platform

FOracle Cloud

Answer : B, D, E

Question 2

Which copy INTO command outputs the data into one file?

ASINGLE=TRUE

BMAX_FILE_NUMBER=1

CFILE_NUMBER=1

DMULTIPLE=FAISE

Answer : A

Question 3

Which of the following objects are contained within a schema? (Choose two.)

ARole

BStream

CWarehouse

DExternal table

EUser

FShare

Answer : C, D

Question 4

How can a row access policy be applied to a table or a view? (Choose two.)

AWithin the policy DDL

BWithin the create table or create view DDL

CBy future APPLY for all objects in a schema

DWithin a control table

EUsing the command ALTER <object> ADD ROW ACCESS POLICY ;

Answer : B, D

Question 5

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

ACreate a zero-copy clone of the worksheet and grant permissions to teammates

BCreate a private Data Exchange so that any teammate can use the worksheet

CShare the worksheet with teammates within Snowsight

DCreate a database and grant all permissions to teammates

Answer : C

Question 6

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

AIncrease the warehouse size from Medium to 2XL.

BIncrease the value for the parameter MAX_CONCURRENCY_LEVEL.

CConfigure the warehouse to a multi-cluster warehouse.

DLower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer : B

Question 7

What are value types that a VARIANT column can store? (Select TWO)

ASTRUCT

BOBJECT

CBINARY

DARRAY

ECLOB

Answer : B, D

Characteristics of a VARIANT

A VARIANT can store a value of any other type, includingOBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

Snowflake SnowPro Core Recertification COF-R02 Exam Practice Test