COF-R02 by Snowflake Actual Free Exam Questions And Answers

Question 1

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A. The new query is run using the same virtual warehouse as the previous query

B. The query has been run within 24 hours of the previously-run query

C. The query includes a User Defined Function (UDF)

D. The user has the appropriate privileges on the objects associated with the query

E. Micro-partitions have been reclustered since the query was last run

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

A. Double the numbers of servers In the compute duster

B. Higher storage costs

C. More micro-partitions

D. Better query scheduling

Discussion 0

Correct Answer: A Vote an answer

Question 3

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

A. Time Travel

B. Row level access policies

C. External tokenization

D. Data encryption

E. Data masking policies

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A. SnowCLI

B. SnowSQL

C. SnowCD

D. SnowUI

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

When can a Virtual Warehouse start running queries?

A. 12am-5am

B. Only during administrator defined time slots

C. After replication

D. When its provisioning is complete

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A. Number of partitions scanned

B. Bytes scanned

C. External bytes scanned

D. Bytes sent over the network

E. Percentage scanned from cache

Discussion 0

Correct Answer: A,B Vote an answer

Question 7

Which of the following are benefits of micro-partitioning? (Select TWO)

A. Micro-partitions cannot overlap in their range of values

B. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

C. Rows are automatically stored in sorted order within micro-partitions

D. Micro-partitions are immutable objects that support the use of Time Travel.

E. Micro-partitions can be defined on a schema-by-schema basis

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

A. Okta Verify

B. Microsoft Authenticator

C. Duo Mobile

D. Google Authenticator

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

A. False

B. True

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A. Serverless query engine

B. Multi-cluster shared data

C. Shared-disk

D. Shared-nothing

Discussion 0

Correct Answer: B Vote an answer

Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test

Contact Us

Useful Links

Latest Updated