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: 2 / 10
Total 330 questions

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

A.

True

B.

False

True or False: An active warehouse is required to run a COPY INTO statement.

A.

True

B.

False

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

A.

True

B.

False

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.

A.

True

B.

False

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

A.

True

B.

False

True or False: The COPY command must specify a File Format in order to execute.

A.

True

B.

False

Snowflake is designed for which type of workloads? (Choose two.)

A.

OLAP (Analytics) workloads

B.

OLTP (Transactional) workloads

C.

Concurrent workloads

D.

On-premise workloads

Which type of table corresponds to a single Snowflake session?

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

A.

Is available to all Snowflake Editions

B.

Is only available to customers with Business Critical Edition

C.

Restricts or enables access to specific IP addresses

D.

Is activated using an “ALTER DATABASE” command

True or False: A single database can exist in more than one Snowflake account.

A.

True

B.

False