Free Practice Snowflake SnowPro-Core Exam Questions 2025

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

Page: 1 / 171

Total 851 Questions | Updated On: Apr 09, 2025

Add To Cart

Question 1

Snowflake's access control framework combines which models for securing data? (Select TWO).

A : Attribute-based Access Control (ABAC)

B : Discretionary Access Control (DAC)

C : Access Control List (ACL)

D : Role-based Access Control (RBAC)

E : Rule-based Access Control (RuBAC)

Answer: B,D

Question 2

How many days is load history for Snowpipe retained?

A : 1 day

B : 7 days

C : 14 days

D : 64 days

Answer: C

Question 3

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

Question 4

What are benefits of using Snowpark with Snowflake? (Select TWO).

A : Snowpark uses a Spark engine to generate optimized SQL query plans.

B : Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C : Snowpark does not require that a separate cluster be running outside of Snowflake.

D : Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E : Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Answer: C,D

Question 5

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A : File URL

B : Scoped URL

C : Relative URL

D : Pre-Signed URL

Answer: B

Page: 1 / 171

Total 851 Questions | Updated On: Apr 09, 2025

Add To Cart