Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 171

Total 851 Questions | Updated On: Mar 26, 2025

Add To Cart

Question 1

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A : Queries against large tables where frequent DML occurs

B : Queries against tables larger than 1 TB

C : Selective point lookup queries

D : Queries against a subset of columns in a table

Answer: C

Question 2

What is the MAXIMUM data retention period of transient databases when using the Snowflake Enterprise edition?

A : 1 day

B : 7 days

C : 30 days

D : 90 days

Answer: A

Question 3

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

A : CREATE STAGE

B :

C :

D : CREATE PIPE

Answer: C

Question 4

The property mins_to_bypass_network_policy is set at which level?

A : User

B : Role

C : Account

D : Organization

Answer: C

Question 5

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

A : If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B : If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C : If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D : If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E : If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Answer: A,B

Page: 1 / 171

Total 851 Questions | Updated On: Mar 26, 2025

Add To Cart