Free Snowflake SnowPro-Core Exam Questions

Become Snowflake Certified with updated SnowPro-Core exam questions and correct answers

Page: 1 / 184

Total 917 Questions | Updated On: Aug 15, 2025

Add To Cart

Question 1

The property mins_to_bypass_network_policy is set at which level?

A : User

B : Role

C : Account

D : Organization

Answer: C

Question 2

What does a Query Profile metric that shows excessive spillage indicate?

A : Poor query optimization

B : Expired temporary tables

C : Improper virtual warehouse sizing

D : Improper Common Table Expressions (CTEs)

Answer: C

Question 3

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A :

B : Specify the TEMPORARY option when creating the file format.

C :

D : Use the REMOVE command after the load completes.

E : Use the DELETE LOAD HISTORY command after the load completes.

Answer: C,E

Question 4

In Snowflake. where can query pruning information statistics be identified?

A : Partitions scanned

B : Byles scanned

C : Bytes spilled to remote storage

D : Percentage scanned from cache

Answer: A

Question 5

A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?

A : BUILD_SCOPED_FILE_URL

B : BUILD_STAGE_FILE_URL

C : GET_PRESIGNED_URL

D : GET STAGE LOCATION

Answer: C

Page: 1 / 184

Total 917 Questions | Updated On: Aug 15, 2025

Add To Cart