Snowflake SnowPro-Core Actual Free Exam Questions & Community Discussion

Exam Code/Number: SnowPro-Core
Exam Name/Title: SnowPro Core Certification Exam
Certification Provider: Snowflake
Corresponding Certification: SnowPro Core

Exam Questions: 630
Updated On: Sep 10, 2026

Question #11

What happens when a suspended virtual warehouse is resized in Snowflake?

A. It will return a warning.

B. It will return an error.

C. The suspended warehouse is resumed and new compute resources are provisioned immediately.

D. The additional compute resources are provisioned when the warehouse is resumed.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #12

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A. REPLACE_INVALID_CHARACTERS

B. SKIP_BYTE_ORDER_MARK

C. STRIP_NULL_VALUES

D. VALIDATION_MODE

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A. The warehouse size does not change until the warehouse is suspended and restarted.

B. The warehouse size does not change until all queries currently in the warehouse queue have completed.

C. The warehouse size does not change until all queries currently running in the warehouse have completed.

D. It does not return from the command until the warehouse has finished changing its size.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

Will data cached in a warehouse be lost when the warehouse is resized?

A. Yes. became the new compute resource will no longer have access to the cache encryption key

B. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

C. No. because the size of the cache is independent from the warehouse size

D. Yes. because the compute resource is replaced in its entirety with a new compute resource.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

A. CHECK_JSON

B. GET_PATH

C. PARSE JSON

D. FLATTEN

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #16

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

A. 10 minutes

B. 14 minutes

C. 24 minutes

D. 4 minutes

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #17

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

A. Data storage

B. Metadata

C. Authentication

D. Query execution

E. Compute resources

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #18

How do secure views compare to non-secure views in Snowflake?

A. Secure views are similar to materialized views in that they are the most performant.

B. There are no performance differences between secure and non-secure views.

C. Secure views execute slowly compared to non-secure views.

D. Non-secure views are preferred over secure views when sharing data.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #19

How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?

A. Use the validation mode = return rows statement.

B. Load the data into a CSV file.

C. Load the data into a relational table.

D. Use the VALlDATlON_MODE - SQL statement.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #20

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

A. Metadata Management

B. Query Processing

C. Database Storage

D. Cloud Services

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Snowflake SnowPro-Core Demo

Simply submit your e-mail address below to get started with our free demo of your Snowflake SnowPro-Core exam.