Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

Which Snowflake tool would be BEST to troubleshoot network connectivity?

ASnowCLI

BSnowUI

CSnowSQL

DSnowCD

Answer : D

https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

Question 2

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

ACREATE_SHARE on the account

BSHARE on databases and schemas

CSELECT on tables used by the secure view

DREFERENCE_USAGE on databases

Answer : C

Question 3

A materialized view should be created when which of the following occurs? (Choose two.)

AThere is minimal cost associated with running the query.

BThe query consumes many compute resources every time it runs.

CThe base table gets updated frequently.

DThe query is highly optimized and does not consume many compute resources.

EThe results of the query do not change often and are used frequently.

Answer : C, E

Question 4

What privilege should a user be granted to change permissions for new objects in a managed access schema?

AGrant the OWNERSHIP privilege on the schema.

BGrant the OWNERSHIP privilege on the database.

CGrant the MANAGE GRANTS global privilege.

DGrant ALL privileges on the schema.

Answer : C

Question 5

Which of the following can be used when unloading data from Snowflake? (Choose two.)

AWhen unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

BUse the ENCODING file format option to change the encoding from the default UTF-8.

CThe OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

DBy using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

EUse the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Answer : A, D

Question 6

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 7

How many resource monitors can be assigned at the account level?

Answer : A

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test