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 #1

What is the default character set used when loading CSV files into Snowflake?

A. ISO S859-1

B. UTF-8

C. UTF-16

D. ANSI_X3.A

Discussion 0

Correct Answer: B Vote an answer

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

Question #2

User-level network policies can be created by which of the following roles? (Select TWO).

A. SYSADMIN

B. USERADMIN

C. ROLEADMIN

D. SECURITYADMIN

E. ACCOUNTADMIN

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #3

Which Snowflake data governance feature can support auditing when a user query reads column data?

A. Access History

B. Object dependencies

C. Data classification

D. Column-level security

Discussion 0

Correct Answer: A Vote an answer

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

Question #4

How does Snowflake handle the bulk unloading of data into single or multiple files?

A. It assigns each unloaded data file a unique name.

B. It uses the put command to download the data by default.

C. It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.

D. It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.

Discussion 0

Correct Answer: A Vote an answer

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

Question #5

What is true about sharing data in Snowflake? (Choose two.)

A. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

B. A Snowflake account can both provide and consume shared data.

C. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

D. The Data Consumer pays only for compute resources to query the shared data.

E. The Data Consumer pays for data storage as well as for data computing.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #6

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

A. Create a database and grant all permissions to teammates

B. Create a zero-copy clone of the worksheet and grant permissions to teammates

C. Create a private Data Exchange so that any teammate can use the worksheet

D. Share the worksheet with teammates within Snowsight

Discussion 0

Correct Answer: D Vote an answer

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

Question #7

What does a masking policy consist of in Snowflake?

A. A single data type, with one or more conditions, and one or more masking functions

B. Multiple data types, with one or more conditions, and one or more masking functions

C. Multiple data types, with only one condition, and one or more masking functions

D. A single data type, with only one condition, and only one masking function

Discussion 0

Correct Answer: A Vote an answer

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

Question #8

Who can grant object privileges in a regular schema?

A. Schema owner

B. SYSADMIN

C. Database owner

D. Object owner

Discussion 0

Correct Answer: D Vote an answer

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

Question #9

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Discussion 0

Correct Answer: B Vote an answer

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

Question #10

Which function should be used to find the query ID of the second query executed in a current session?

A. Select LAST_QUERY_ID(2)

B. Select LAST_QUERY_ID(2)

C. Select LAST_QUERY_ID(-2)

D. Select LAST_QUERY_ID(1)

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.