Snowflake COF-R02 Exam Practice Test Instant Access

Question 1

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 2

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

ATrue

BFalse

Answer : A

Question 3

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

ACompute resources

BQuery execution

CAuthentication

DData storage

EMetadata

Answer : C, E

Question 4

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A30 days

B7 days

C48 hours

D24 hours

Answer : D

Question 5

A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

AOrganize files into logical paths

BStore the files on the external stage to ensure caching is maintained

CUse pattern matching for regular expression execution

DLoad the data in one large file

Answer : D

Question 6

What are supported file formats for unloading data from Snowflake? (Choose three.)

AXML

BJSON

CParquet

DORC

EAVRO

FCSV

Answer : B, C, F

Question 7

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

ATrue

BFalse

Answer : B

Snowflake SnowPro Core Recertification COF-R02 Exam Practice Test