Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Snowflake
SnowPro Core Certification
COF-R02
SnowPro Core Recertification Exam Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam COF-R02 Premium Access

View all detail and faqs for the COF-R02 exam

Go to Exam

715 Students Passed

91% Average Score

92% Same Questions

Viewing page 2 out of 10 pages

Viewing questions 11-20 out of questions

Questions # 11:

True or False: During data unloading, only JSON and CSV files can be compressed.

Options:

True

False

Answer

Explanation

[Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html, , ]

Questions # 12:

Which type of table corresponds to a single Snowflake session?

Options:

Temporary

Translent

Provisional

Permanent

Answer

Explanation

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session .

Questions # 13:

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

Options:

True

False

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/connecting.html, , ]

Questions # 14:

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

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/warehouses.html, ]

Questions # 15:

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Options:

Concurrency

Performance

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html, , ]

Questions # 16:

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Options:

Standard

Premier

Enterprise

Business Critical Edition

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html, ]

Questions # 17:

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

Options:

True

False

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html, , ]

Questions # 18:

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

Options:

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

Answer

A, C

Explanation

[Reference: https://blog.couchbase.com/its-the-workload-stupid/, https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing]

Questions # 19:

What privileges are required to create a task?

Options:

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

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

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

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

Answer

Explanation

All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.

https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Questions # 20:

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.