New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Snowflake COF-R02 - SnowPro Core Recertification Exam

Snowflake COF-R02 Premium Access     Download Demo    
Page: 3 / 10
Total 330 questions

Which of the following statements is true of Snowflake?

A.

It was built specifically for the cloud

B.

It was built as an on-premises solution and then ported to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

Which interfaces can be used to create and/or manage Virtual Warehouses?

A.

The Snowflake Web Interface (UI)

B.

SQL commands

C.

Data integration tools

D.

All of the above

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

A.

True

B.

False

Which of the following statements would be used to export/unload data from Snowflake?

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

True or False: Snowflake charges a premium for storing semi-structured data.

A.

True

B.

False

Which of the following terms best describes Snowflake’s database architecture?

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A.

4

B.

16

C.

32

D.

128

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

What privileges are required to create a task?

A.

The global privilege create task is required to create a new task.

B.

Tasks are created at the Application level and can only be created by the Account Admin role.

C.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

D.

The role must have access to the target schema and the create task privilege on the schema itself.