Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

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

Answer : A

Question 2

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 3

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 4

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 5

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 6

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

ACOPY INTO

BCREATE PIPE

CINSERT INTO

DTABLE STREAM

Answer : B

Question 7

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

ATSV

BJSON

CPDF

DAvro

EParquet

FJPEG

Answer : B, D, E

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test