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

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

AJSON

BBINARY

CVARCHAR

DVARIANT

Answer : D

Question 3

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

AA directory table is a separate database object.

BDirectory tables store data file metadata.

CA directory table will be automatically added to a stage.

DDirectory tables do not have their own grantable privileges.

EDirectory table data can not be refreshed manually.

Answer : B, D

Question 4

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

AUSERADMIN

BPUBLIC

CORGADMIN

DSYSADMIN

Answer : D

Question 5

Which statement describes how Snowflake supports reader accounts?

AA reader account can consume data from the provider account that created it and combine it with its own data.

BA consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

CThe users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

DThe SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Answer : C

Question 6

Which of the following statements describes a schema in Snowflake?

AA logical grouping of objects that belongs to a single database

BA logical grouping of objects that belongs to multiple databases

CA named Snowflake object that includes all the information required to share a database

DA uniquely identified Snowflake account within a business entity

Answer : A

Question 7

What is the recommended compressed file size range for continuous data loads using Snowpipe?

A8-16 MB

B16-24 MB

C10-99 MB

D100-250 MB

Answer : B

Snowflake COF-R02 SnowPro Core Recertification Exam Practice Test