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 5 out of 10 pages

Viewing questions 41-50 out of questions

Questions # 41:

Which feature is only available in the Enterprise or higher editions of Snowflake?

Options:

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

Answer

Explanation

https://docs.snowflake.com/en/user-guide/intro-editions.html

Questions # 42:

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

Answer

B, D

Explanation

https://docs.snowflake.com/en/user-guide/intro-editions.html

Questions # 43:

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Options:

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

Answer

B, C

Explanation

https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.

Questions # 44:

What Snowflake role must be granted for a user to create and manage accounts?

Options:

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

Answer

Explanation

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Questions # 45:

Which of the following describes how clustering keys work in Snowflake?

Options:

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Answer

Questions # 46:

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Options:

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

Answer

A, D

Questions # 47:

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Options:

VARIANT

ARRAY

VARCHAR

XML

BLOB

Answer

A, B

Explanation

https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

The maximum length of a VARIANT is 16 MB.

A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

Questions # 48:

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

Answer

D, E

Explanation

By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses.

An administrator with sufficient permissions can create any number of network policies.

https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies .

Questions # 49:

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)