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: Apr 19, 2025

Add To Cart

Question 1

What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)

A : Stored procedures

B : Stages

C : Tasks

D : Views

E : User-Defined Functions (UDFs)

Answer: A,E

Question 2

The Snowflake VARIANT data Type imposes a 16 MB size limit on what?

A : An individual row

B : An individual column

C : A view

D : A file in a stage

Answer: B

Question 3

Which virtual warehouse configuration requires the maximum number of clusters to be equal to the minimum number of clusters?

A : Auto-scale mode

B : Maximized mode

C : Standard scaling policy

D : Economy scaling policy

Answer: B

Question 4

You want to load a specific list of files from an S3 stage. What is the correct syntax for achieving this?

Assume the file names are

delta1.csv

delta2.csv

delta3.csv

and the stage is called my_stage, and the table is called my_table

A : COPY delta1.csv,delta2.csv,delta3.csv INTO my_table FROM @my_stage

B : COPY INTO my_table FROM @my_stage files=('delta1.csv', 'delta2.csv', 'delta3.csv')

C : COPY INTO my_table FROM @my_stage/delta1.csv,@my_stage/delta2.csv,@my_stage/delta3.csv

Answer: B

Question 5

What step can reduce data spilling in Snowflake?

A : Using a larger virtual warehouse

B : Increasing the virtual warehouse maximum timeout limit

C : Increasing the amount of remote storage for the virtual warehouse

D : Using a common table expression (CTE) instead of a temporary table

Answer: A

Page: 1 / 171

Total 851 Questions | Updated On: Apr 19, 2025

Add To Cart