COF-R02 Real Exam Questions and Verified Answers

Question 1 Single choice

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.

A
True
B
False

Show answer and explanation

Correct answer: A

Question 2 Multiple choice

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A
Snowflake leverages a Role-Based Access Control (RBAC) model.
B
Snowflake requires a user to configure an IAM user to connect to the database.
C
All data in Snowflake is encrypted.
D
Snowflake can run within a user's own Virtual Private Cloud (VPC).
E
All data in Snowflake is compressed.

Show answer and explanation

Correct answers: A, D

Question 3 Multiple choice

Which of the following are valid methods for authenticating users for access into Snowflake? (Select

THREE)

A
SCIM
B
Federated authentication
C
TLS 1.2
D
Key-pair authentication
E
OAuth
F
OCSP authentication

Show answer and explanation

Correct answers: B, D, E

Question 4 Single choice

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

A
CREATE_SHARE on the account
B
SHARE on databases and schemas
C
SELECT on tables used by the secure view
D
REFERENCE_USAGE on databases

Show answer and explanation

Correct answer: C

Question 5 Single choice

Which feature allows a user the ability to control the organization of data in a micro-partition?

A
Range Partitioning
B
Search Optimization Service
C
Automatic Clustering
D
Horizontal Partitioning

Show answer and explanation

Correct answer: D

Question 6 Single choice

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A
SnowCLI
B
SnowUI
C
SnowSQL
D
SnowCD

Show answer and explanation

Correct answer: D

Explanation

https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

Question 7 Single choice

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

A
4 minutes
B
10 minutes
C
14 minutes
D
24 minutes

Show answer and explanation

Correct answer: C

Question 8 Multiple choice

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A
The ability to scale up warehouses
B
The use of warehouse auto scaling
C
The ability to resize warehouses
D
Use of multi-clustered warehouses
E
The use of warehouse indexing

Show answer and explanation

Correct answers: B, D

Question 9 Single choice

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A
Configure the Maximum Clusters setting to "Auto-Scale"
B
Set the Warehouse type to "Auto"
C
Set the Minimum Clusters and Maximum Clusters settings to the same value
D
Set the Minimum Clusters and Maximum Clusters settings to the different values

Show answer and explanation

Correct answer: D

Explanation

References:
https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

Question 10 Single choice

What are the default Time Travel and Fail-safe retention periods for transient tables?

A
Time Travel-1 day. Fail-safe-1 day
B
Time Travel-0 days. Fail-safe-1 day
C
Time Travel-1 day. Fail-safe-0 days
D
Transient tables are retained in neither Fail-safe nor Time Travel

Show answer and explanation

Correct answer: C

Explanation

https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe%20period.