SnowPro-Core Snowflake SnowPro Core Certification Exam exact Exam Questions

SnowPro Core Certification Exam

Last Update 8 hours ago Total Questions : 605

The SnowPro Core Certification Exam content is now fully updated, with all current exam questions added 8 hours ago. Deciding to include SnowPro-Core practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our SnowPro-Core exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these SnowPro-Core sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Core Certification Exam practice test comfortably within the allotted time.

Question # 166

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Row access policies

Data masking policies

Data encryption

Role based access control

Question # 167

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

NUMBER

OBJECT

STRING

VARCHAR

VARIANT

Question # 168

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Materialized View

Pipe

Stream

Task

Question # 169

When unloading data with the COPY into < location > command, what is the purpose of the PARTITION BY < expression > parameter option?

To sort the contents of the output file by the specified expression.

To delimit the records in the output file using the specified expression.

To include a new column in the output using the specified window function expression.

To split the output into multiple files, one for each distinct value of the specified expression.

Question # 170

When should a stored procedure be created with caller ' s rights?

A.
When the caller needs to be prevented from viewing the source code of the stored procedure

B.
When the caller needs to run a statement that could not execute outside of the stored procedure

C.
When the stored procedure needs to run with the privileges of the role that called the stored procedure

D.
When the stored procedure needs to operate on objects that the caller does not have privileges on

Answer:

C

Explanation:

Stored procedures in Snowflake can be created with either ' owner ' s rights ' or ' caller ' s rights ' . A stored procedure created with caller ' s rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller ' s access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.
[Reference: Snowflake's official documentation on stored procedures, specifically the section on execution context (caller's rights vs. owner's rights), provides detailed guidance on when to use caller's rights: https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#caller-s-rights-vs-owner-s-rights, , ]

Question # 171

Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

A.
Security

B.
Data storage

C.
Data visualization

D.
Query computation

E.
Metadata management

Answer:

A, E

Explanation:

The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). References: Based on general cloud architecture knowledge as of 2021.

Question # 172

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

A.
ROW_NUMBER

B.
TABLE

C.
TABULAR

D.
VALUES

Answer:

B

Explanation:

In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword “TABLE.” This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query. References: Based on my internal knowledge as of 2021.

Question # 173

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

Explanation:

Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake’s virtual warehouses, eliminating the need for a separate cluster. Additionally, Snowpark’s compatibility with Spark allows users to leverage their existing Spark code with minimal changes 1 .

Question # 174

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

A.
READ

B.
OWNERSHIP

C.
USAGK

D.
WRTTF

Answer:

A

Explanation:

The minimum privilege required on an external stage for any role to access unstructured data files using a file URL in the GET REST API is READ. This allows the role to retrieve or download data files from the stage.

Question # 175

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

A.
Java

B.
Javascript

C.
Scala

D.
Python

E.
SQL

Answer:

B, E

Explanation:

User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF 2 .

Question # 176

How can a Snowflake user access a JSON object, given the following table? (Select TWO).

A.
src:salesperson.name

B.
src:sa1esPerson. name

C.
src:salesperson.Name

D.
SRC:salesperson.name

E.
SRC:salesperson.Name

Answer:

A, C

Explanation:

To access a JSON object in Snowflake, dot notation is used where the path to the object is specified after the column name containing the JSON data. Both lowercase and uppercase can be used for attribute names, so both “name” and “Name” are valid. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question # 177

Which formats does Snowflake store unstructured data in? (Choose two.)

A.
GeoJSON

B.
Array

C.
XML

D.
Object

E.
BLOB

Answer:

A, C

Explanation:

Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML 1 . GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question # 178

Which items are considered schema objects in Snowflake? (Select TWO).

A.
Pipe

B.
File format

C.
Resource monitor

D.
Storage integration

E.
Virtual warehouse

Answer:

A, B

Explanation:

In Snowflake, schema objects include Pipes and File formats. Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake

Question # 179

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A.
TSV

B.
JSON

C.
PDF

D.
Avro

E.
Parquet

F.
JPEG

Answer:

B, D, E

Explanation:

Snowflake supports several semi-structured data formats for loading data. The supported formats include JSON, Avro, and Parquet 1 2 . These formats allow for efficient storage and querying of data that does not conform to a traditional relational database schema.

Question # 180

Which data type can store more than one type of data structure?

A.
JSON

B.
BINARY

C.
VARCHAR

D.
VARIANT

Answer:

D

Explanation:

The VARIANT data type in Snowflake can store multiple types of data structures, as it is designed to hold semi-structured data. It can contain any other data type, including OBJECT and ARRAY, which allows it to represent various data structures

Go to page:
<< First

Prev

4

5

6

7

8

9

10

11

12

13

Next

Last >>

SnowPro-Core PDF + Testing Engine

~~$149.97~~
$44.99

Last Update: Jun 4, 2026

605 Questions and Answers

Single Choice: 445 Q&A's

Multiple Choice: 160 Q&A's

View Packages

Related Snowflake Certification Exams

Snowflake ADA-R01

Snowflake DAA-C01

Snowflake DAA-R01

Snowflake DEA-C02

Snowflake DEA-R01

Snowflake DEA-R02

Snowflake DSA-C03

Snowflake DSA-R02

Snowflake DSA-R03

Snowflake SOL-C01

Snowflake SPS-C01

Snowflake ADA-P01

New Release

AFP-Exam-1 Exam Questions

D-PE-OE-01 Exam Questions

DSPM- Deploy-and-Administer Exam Questions

NJ-Life-Producer Exam Questions

Copado-Extension-Builder Exam Questions

Category-Manager Exam Questions

Drupal-Site-Builder Exam Questions

NCP-OUSD Exam Questions

IdentityIQ-Associate Exam Questions

M92 Exam Questions

ISO-IEC-27002-Foundation Exam Questions

NCP-AAI Exam Questions

VNX301 Exam Questions

AI-901 Exam Questions

Als-Con-201 Exam Questions

Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Exact2Pass

SnowPro Core Certification Exam

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

SnowPro-Core PDF + Testing Engine

Related Snowflake Certification Exams

New Release

SubFooter