Free Practice Snowflake COF-C02 Exam Questions 2025

Stay ahead with 100% Free SnowPro Core Certification COF-C02 Dumps Practice Questions

Page: 1 / 171

Total 851 Questions | Updated On: Apr 09, 2025

Add To Cart

Question 1

How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?

A : Log in to the data consumer account and check if the secure view data is appearing as expected.

B : Create a data share for a test data consumer account and check if the secure view data is appearing as expected.

C : Query the secure view from a consumer account by setting the share_restrictions parameter.

D : Simulate querying the secure view by setting the simulated_data_sharing_consumer session parameter.

Answer: B

Question 2

Which type of short-lived Snowflake tables will continue to exist even if the session is closed?

A : Permanent

B : Co-existent

C : Temporary

D : Transient

Answer: D

Question 3

For how long a query remains visible on the query history page in the Snowsight interface?

A : 3 months

B : 60 minutes

C : 14 days

D : 28 days

Answer: C

Question 4

In the Snowflake access control model, which entity owns an object by default?

A : The user who created the object

B : The SYSADMIN role

C : Ownership depends on the type of object

D : The role used to create the object

Answer: D

Question 5

What role is required to use Partner Connect?

A : ACCOUNTADMIN

B : ORGADMIN

C : SECURITYADMIN

D : SYSADMIN

Answer: A

Page: 1 / 171

Total 851 Questions | Updated On: Apr 09, 2025

Add To Cart