Free Practice Snowflake SnowPro-Core Exam Questions 2026

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

Page: 1 / 194

Total 970 Questions | Updated On: Feb 18, 2026

Add To Cart

Question 1

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A : Business Critical Edition

B : Standard Edition

C : Virtual Private Snowflake (VPS)

D : Enterprise Edition

Answer: D

Question 2

What is the LEAST-PRIVILEGED role that can create a share in Snowflake by default?

A : SYSADMIN

B : SECURITYADMIN

C : USERADMIN

D : ACCOUNTADMIN

Answer: B

Question 3

What does Snowflake recommend regarding database object ownership? (Select TWO).

A : Create objects with ACCOUNTADMIN and do not reassign ownership.

B : Create objects with SYSADMIN.

C : Create objects with SECURITYADMIN to ease granting of privileges later.

D : Create objects with a custom role and grant this role to SYSADMIN.

E : Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Answer: B,D

Question 4

When a schema is cloned what happens to the tags that reside in that schema or database?

A : The tags are deleted and must be redefined in the target schema.

B : The tags remain in the source schema unchanged.

C : The tags become temporarily inactive until they are manually reactivated.

D : The tags are automatically cloned with the schema, maintaining all associations.

Answer: D

Question 5

A user needs to MINIMIZE the cost of large tables that are used to store transitory dat a. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?

A : Permanent

B : Transient

C : Temporary

D : Externa

Answer: B

Page: 1 / 194

Total 970 Questions | Updated On: Feb 18, 2026

Add To Cart