Snowflake COF-R02 Exam Questions Free Practice Test

Viewing page 1 out of 10 pages

Viewing questions 1-10 out of questions

Questions # 1:

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

Options:

The complexity of each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

Expert Solution

Questions # 2:

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

Options:

The tables are now orphaned

The user that deleted the role

SYSADMIN

The assumed role that dropped the role

Expert Solution

Questions # 3:

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

Options:

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

Expert Solution

Questions # 4:

Which type of table corresponds to a single Snowflake session?

Options:

Temporary

Translent

Provisional

Permanent

Expert Solution

Questions # 5:

Which of the following objects is not covered by Time Travel?

Options:

Tables

Schemas

Databases

Stages

Expert Solution

Questions # 6:

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

Options:

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

Expert Solution

Questions # 7:

Which of the following statement is true of Snowflake?

Select one.

Options:

It was built specifically for the cloud

it was built as an on-premises solution and then potted to the cloud

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

It was built for Hadoop architecture

It's based on an Oracle Architecture

Expert Solution

Questions # 8:

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Options:

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Expert Solution

Questions # 9:

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

Options:

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

Expert Solution

Questions # 10:

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Options:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Expert Solution

Viewing page 1 out of 10 pages

Viewing questions 1-10 out of questions

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with CertsForce