Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 194

Total 970 Questions | Updated On: Dec 05, 2025

Add To Cart

Question 1

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

A : Use Snowpipe.

B : Use the INSERT command.

C : Use an external table.

D : Use the COPY command.

Answer: D

Question 2

How are serverless features billed?

A : Per second multiplied by an automatic sizing for the job

B : Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C : Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D : Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Answer: B

Question 3

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A : Bytes scanned

B : Bytes sent over the network

C : Number of partitions scanned

D : Percentage scanned from cache

E : External bytes scanned

Answer: A,C

Question 4

Which of the following SQL statements will list the version of the drivers currently being used?

A : Execute SELECT CURRENT_ODBC_CLlENT(); from the Web Ul

B : Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

C : Execute SELECT CURRENT_CLIENT(); from an application

D : Execute SELECT CURRENT_VERSION (); from the Python Connector

Answer: B

Question 5

What is the primary purpose of a directory table in Snowflake?

A : To store actual data from external stages

B : To automatically expire file URLs for security

C : To manage user privileges and access control

D : To store file-level metadata about data files in a stage

Answer: D

Page: 1 / 194

Total 970 Questions | Updated On: Dec 05, 2025

Add To Cart