Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

ASTRIP_NULL_VALUES

BSKIP_BYTE_ORDER_MARK

CREPLACE_INVALID_CHARACTERS

DVALIDATION_MODE

Answer : D

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

VALIDATION_MODE=RETURN_n_ROWS|RETURN_ERRORS|RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data filesinsteadof loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

Question 2

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

Answer : A

Question 3

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

ASHOW STORAGE BY TABLE;

BSHOW TABLES;

CInformation Schema -> TABLE_HISTORY

DInformation Schema -> TABLE_FUNCTION

EInformation Schema -> TABLE_STORAGE_METRICS

Answer : A, E

Question 4

How would a user run a multi-cluster warehouse in maximized mode?

AConfigure the maximum clusters setting to 'Maximum.'

BTurn on the additional clusters manually after starting the warehouse.

CSet the minimum Clusters and maximum Clusters settings to the same value.

DSet the minimum clusters and maximum clusters settings to different values.

Answer : D

Question 5

What internal stages are available in Snowflake? (Choose three.)

ASchema stage

BNamed stage

CUser stage

DStream stage

ETable stage

FDatabase stage

Answer : A, B, E

Question 6

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

ASchema Stage

BUser Stage

CDatabase Stage

DTable Stage

EExternal Named Stage

FInternal Named Stage

Answer : A, E, F

Question 7

Which data type can store more than one type of data structure?

AJSON

BBINARY

CVARCHAR

DVARIANT

Answer : D

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test