Free Snowflake SnowPro-Core Exam Questions

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

Page: 1 / 184

Total 917 Questions | Updated On: Sep 09, 2025

Add To Cart

Question 1

A user needs to know the maximum value of a date field in a table, and runs the following query: ....part of Snowflake architecture wilt this query use?

A : Database Storage

B : Query Processing

C : Cloud Services

D : Compute

Answer: A

Question 2

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

A : A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

B : A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

C : A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

D : Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Answer: B

Question 3

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

A : Clone the table schema as it existed before the table was dropped.

B : Clone the database as it existed before the table was dropped.

C : Recreate the table and reload the data.

D : Run the UNDROP command against the table.

Answer: D

Question 4

Which view will show the MOST recent information about table-level storage utilization?

A : The TABLE_STORAGE_METRICS view in a Snowflake data share

B : The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema

C : The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA

D : The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA

Answer: B

Question 5

What are benefits of using Snowpark with Snowflake? (Select TWO).

A : Snowpark uses a Spark engine to generate optimized SQL query plans.

B : Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C : Snowpark does not require that a separate cluster be running outside of Snowflake.

D : Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E : Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Answer: C,D

Page: 1 / 184

Total 917 Questions | Updated On: Sep 09, 2025

Add To Cart