Palo Alto Networks

Snowflake SnowPro Core SnowPro Core Dumps in PDF

Free Snowflake SnowPro Core Real Questions (page: 2)

Page 2 of 139 SnowPro Core PDF — 1300 Questions

QUESTION: 9

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users
Warehouse size
Amount of data processed
# of clusters for the Warehouse

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 10

Which statement best describes `clustering`?

Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
The database administrator must define the clustering methodology for each Snowflake table
The clustering key must be included on the COPY command when loading data into Snowflake
Clustering can be disabled within a Snowflake account

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Reveal Solution Next Question

QUESTION: 11

True or False: The COPY command must specify a File Format in order to execute.

True
False

Answer(s): B

Reveal Solution Next Question

QUESTION: 12

Which of the following commands sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <<config file>>;
SET WAREHOUSE = <<warehouse name>>;
USE WAREHOUSE <<warehouse name>>;
USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer(s): C

Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

Reveal Solution Next Question

QUESTION: 13

Which of the following objects can be cloned? (Choose four.)

Tables
Named File Formats
Schemas
Shares
Databases
Users

Answer(s): A,B,C,E

Reveal Solution Next Question

QUESTION: 14

Which object allows you to limit the number of credits consumed within a Snowflake account?

Account Usage Tracking
Resource Monitor
Warehouse Limit Parameter
Credit Consumption Tracker

Answer(s): B

Reference:

https://docs.snowflake.com/en/user-guide/resource-monitors.html

Reveal Solution Next Question

QUESTION: 15

Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads
OLTP (Transactional) workloads
Concurrent workloads
On-premise workloads

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 16

What are the three layers that make up Snowflake's architecture? (Choose three.)

Compute
Tri-Secret Secure
Storage
Cloud Services

Answer(s): A,C,D

Reference:

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Reveal Solution Next Question

1
2
3
4
5
…
10
20
30
40

Viewing page 2 of 139

Share your comments for Snowflake SnowPro Core exam with other users:

Comments:

Name:

A

AI Tutor Explanation

9/24/2026 11:16:10 AM

Question 5:
Correct answer: A — True
Snowflake supports bulk unloading with COPY INTO <location> using a SELECT statement as the source. This allows you to export either:

All or selected columns from a table
Filtered rows using WHERE
Transformed or joined data

Example:

sql 
COPY INTO @my_stage/export/ 
FROM ( 
  SELECT customer_id, order_date 
  FROM orders 
  WHERE order_date >= '2025-01-01' 
);

Snowflake writes the query results to files in the specified internal or external stage. The key distinction is that COPY INTO is used for bulk movement of data, while a regular SELECT only returns query results and does not unload them to staged files.

A

AI Tutor Explanation

9/3/2026 5:25:59 AM

Question 1:
Correct answer: B — Clustering keys
Snowflake automatically organizes table data into micro-partitions and uses natural clustering based on how data is loaded. However, for large tables where query performance depends on particular columns, you can define a clustering key.
A clustering key:

Specifies one or more columns or expressions Snowflake should use when organizing table data.
Helps Snowflake’s automatic reclustering keep related rows grouped together.
Can improve pruning for queries that frequently filter or join on those columns.

Why the others are incorrect:

Micro-partitions: Snowflake’s storage units; users do not directly define them as an override mechanism.
Key partitions: Not a Snowflake feature.
Clustered partitions: Not the name of the customer-defined mechanism.

The answer key’s B is correct.

A

AI Tutor Explanation

8/28/2026 11:39:56 AM

Question 17:
Correct answer: D — To accommodate a more complex workload.
Increasing a Virtual Warehouse from X-Small to Medium is vertical scaling. The larger warehouse provides more compute resources, which can improve performance for:

Complex queries
Large scans or joins
Resource-intensive transformations
Queries involving substantial processing

Why the others are less appropriate:

More users / more queries: This usually calls for multi-cluster warehouses, which add clusters to handle concurrency.
Fluctuations in workload: This is typically addressed with auto-suspend/auto-resume or multi-cluster scaling, rather than simply choosing a larger warehouse.

Thus, warehouse size primarily affects the compute power available to individual workloads.

AI Tutor 👋 I’m here to help!