Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

Using variables in Snowflake is denoted by using which SQL character?

Answer : C

Question 2

What is cached during a query on a virtual warehouse?

AAll columns in a micro-partition

BAny columns accessed during the query

CThe columns in the result set of the query

DAll rows accessed during the query

Answer : B

Question 3

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

AWhen after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

BWhen after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

CWhen after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

DWhen after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Answer : D

Question 4

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

AStandard

BEnterprise

CBusiness Critical

DVirtual Private Snowflake

Answer : B

Question 5

How would a user execute a series of SQL statements using a task?

AInclude the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1
WHERE ..

BA stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS
call stored_proc1(); call stored_proc2();

CUse a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

DCreate a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Answer : D

Question 6

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

AThe data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

BThe data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

CThe data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

DThe data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Answer : C

Question 7

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

ASchemas

BRoles

CSecure Views

DStored Procedures

ETables

FSecure User-Defined Functions (UDFs)

Answer : A, B, F

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test