Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 8

Questions 71

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Options:
A.

True

B.

False

Snowflake COF-R02 Premium Access
Questions 72

True or False: Snowflake supports federated authentication in all editions.

Options:
A.

True

B.

False

Questions 73

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Options:
A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Questions 74

Which of the following roles is recommended to be used to create and manage users and roles?

Options:
A.

SYSADMIN

B.

SECURITYADMIN

C.

PUBLIC

D.

ACCOUNTADMIN

Questions 75

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

Options:
A.

True

B.

False

Questions 76

Which of the following statements is true of Snowflake?

Options:
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

Questions 77

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

Options:
A.

True

B.

False

Questions 78

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

Options:
A.

True

B.

False

Questions 79

The PUT command: (Choose two.)

Options:
A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Questions 80

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

Options:
A.

A multi-cluster Warehouse can add clusters automatically based on query activity

B.

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

C.

A multi-cluster Warehouse can scale down when query activity slows

D.

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it