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: Feb 18, 2026

Add To Cart

Question 1

Which clause is used to define a function that may return different values for different rows?

A : IMMUTABLE

B : RETURNS

C : COMMENT

D : VOLATILE

Answer: D

Question 2

How can be Micro-Partitions well defined in SnowFlake?

A : Contiguous units of storage

B : Similar to Static partitioning in Traditional data warehouses

C : Database Micro Services

D : Hybrid Columnar MPP

Answer: A

Question 3

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A : Roles

B : Databases

C : Warehouses

D : Users

E : Accounts

Answer: D,E

Question 4

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

A : Shows how the accessed data was moved from the source lo the target objects

B : Provides a unified picture of what data was accessed and when it was accessed

C : Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime

D : Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data

E : Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Answer: B,E

Question 5

What is the only supported character set for loading and unloading data from all supported file formats?

A : UTF-8

B : UTF-16

C : ISO-8859-1

D : WINDOWS-1253

Answer: A

Page: 1 / 194

Total 970 Questions | Updated On: Feb 18, 2026

Add To Cart