Free SnowPro-Core Practice Exam

Study Smarter for the SnowPro-Core Exam with Our Free and Accurate SnowPro-Core Exam Questions – Updated for 2025.

At Cert Empire, we are committed to delivering the most reliable and up-to-date exam questions for students preparing for the Snowflake SnowPro-Core Exam. To support better preparation, we’ve made sections of our SnowPro-Core exam resources free for everyone. You can practice as much as you want with Free SnowPro-Core Practice Test.

Get SnowPro-Core Exam Dumps

Snowflake SnowPro Core Free Exam Questions

Disclaimer

Please keep a note that the demo questions are not frequently updated. You may as well find them in open communities around the web. However, this demo is only to depict what sort of questions you may find in our original files.

Nonetheless, the premium exam dumps files are frequently updated and are based on the latest exam syllabus and real exam questions.

1 / 60

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Premier

Business Critical Edition

Standard

Enterprise

2 / 60

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

3 / 60

A user has an application that writes a new file to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a GET operation to intermittently check for new files

Create a task that runs a COPY INTO operation from an external stage every 5 minutes

Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest

Create a task that PUTS the files in an internal stage and automate the data loading wizard

4 / 60

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Use data encryption

Use dynamic data masking

Use secure materialized views

Revoke all roles for functional managers and end users

5 / 60

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Compute

Metadata

Data Storage

Cloud Services

6 / 60

What is the default file size when unloading data from Snowflake using the COPY command?

5 MB

16 MB

32 MB

8 GB

7 / 60

What Snowflake role must be granted for a user to create and manage accounts?

SYSADMIN

ORGADMIN

SECURITYADMIN

ACCOUNTADMIN

8 / 60

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

The explain plan output is available graphically

An explain plan can be used to conduct performance analysis without executing a query

An explain plan's output will display automatic data skew optimization information

An explain plan will handle queries with temporary tables and the query profiler will not

9 / 60

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Allows optimization of parallel operations

Allows a user to import the files in a sequential order

Increases the latency staging and accuracy when loading the data

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

10 / 60

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Use a larger-sized warehouse

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command

Compress the file and load the compressed file

Split the file into multiple files in the recommended size range (100 MB - 250 MB)

11 / 60

What is a feature of a stored procedure in Snowflake?

They can only contain a single SQL statement

They can access tables from a single database

They can be created to run with a caller's rights or an owner's rights

They can be created as secure and hide the underlying metadata from all users

12 / 60

What is the minimum Snowflake edition required to create a materialized view?

Enterprise Edition

Standard Edition

Virtual Private Snowflake Edition

Business Critical Edition

13 / 60

How are serverless features billed?

Per second multiplied by an automatic sizing for the job

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

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

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

14 / 60

When unloading to a stage, which of the following is a recommended practice or approach?

Define an individual file format

Avoid the use of the CAST function

Set SINGLE = TRUE for larger files

Use OBJECT_CONSTRUCT(*) when using Parquet

15 / 60

A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

1 second

60 seconds

5 minutes

60 minutes

16 / 60

How long is the Fail-safe period for temporary and transient tables?

1 day

7 day

31 day

90 day

There is no Fail-safe period for these tables

17 / 60

How does Snowflake Fail-safe protect data in a permanent table?

Fail-safe makes data available for 7 days, recoverable by user operations

Fail-safe makes data available up to 1 day, recoverable by user operations

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support

18 / 60

Which minimum Snowflake edition allows for a dedicated metadata store?

Enterprise

Standard

Business Critical

Virtual Private Snowflake

19 / 60

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

20 / 60

What is a key feature of Snowflake architecture?

Software updates are automatically applied on a quarterly basis

Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date

Zero-copy cloning creates a mirror copy of a database that updates with the original

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Snowflake eliminates resource contention with its virtual warehouse implementation

21 / 60

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tables

Materialized Views

External Tokenization

User-Defined Table Functions (UDTF)

22 / 60

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

LOGIN_HISTORY

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

23 / 60

Will data cached in a warehouse be lost when the warehouse is resized?

No, because the size of the cache is independent from the warehouse size

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits

Yes, because the compute resource is replaced in its entirety with a new compute resource

Yes, because the new compute resource will no longer have access to the cache encryption key

24 / 60

Which of the following describes the Snowflake Cloud Services layer?

Manages quotas on the Snowflake account storage

Coordinates activities in the Snowflake account

Manages the virtual warehouse cache to speed up queries

Executes queries submitted by the Snowflake account users

25 / 60

What type of query benefits the MOST from search optimization?

A query that includes analytical expressions

A query that filters on semi-structured data types

A query that uses only disjunction (i.e., OR) predicates

A query that uses equality predicates or predicates that use IN

26 / 60

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

PUT

GET

COPY

INSERT

27 / 60

Which of the following is a data tokenization integration partner?

SAP

DBeaver

Tableau

Protegrity

28 / 60

What is the minimum Snowflake edition that has column-level security enabled?

Enterprise

Standard

Business Critical

Virtual Private Snowflake

29 / 60

Which Snowflake feature is used for both querying and restoring data?

Cloning

Fail-safe

Time Travel

Cluster keys

30 / 60

What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

START_TIME = CURRENT_DATE()

INITIALLY_SUSPENDED = TRUE/FALSE

START_AFTER_CREATE = TRUE/FALSE

START_THE = 60 // (seconds from now)

31 / 60

What is the default File Format used in the COPY command if one is not specified?

XML

CSV

JSON

Parquet

32 / 60

Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?

Account -> Database -> Schema -> Table

Account -> Schema -> Database -> Table

Database -> Table -> Schema -> Account

Database -> Schema -> Table -> Account

33 / 60

Which of the following are options when creating a Virtual Warehouse? (Choose two.)

User count, Local SSD size

Auto-resume, User count

Auto-suspend, Auto-resume

Local SSD size, Auto-suspend

34 / 60

How would you determine the size of the virtual warehouse used for a task?

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

35 / 60

Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning can be disabled within a Snowflake account

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

36 / 60

How a Snowpipe charges calculated?

Total storage bucket size

Number of Pipes in account

Per-second/per-core granularity

Per-second/per Warehouse size

37 / 60

How many shares can be consumed by a single Data Consumer?

100, but can be increased by contacting support

Unlimited

38 / 60

What is the lowest Snowflake edition that offers Time Travel up to 90 days?

Premier Edition

Business Critical Edition

Standard Edition

Enterprise Edition

39 / 60

What privileges are required to create a task?

The GLOBAL privilege CREATE TASK is required to create a new task

Tasks are created at the Application level and can only be created by the Account Admin role

The role must have access to the target schema and the CREATE TASK privilege on the schema itself

Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants

40 / 60

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

41 / 60

The FLATTEN function is used to query which type of data in Snowflake?

Structured data

Semi-structured data

Both of the above

None of the above

42 / 60

When can a Virtual Warehouse start running queries?

12am-5am

When its provisioning is complete

After replication

Only during administrator defined time slots

43 / 60

If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:

There are no users logged into Snowflake

The last query using the Warehouse completes

The Warehouse is inactive for a specified period of time

All Snowflakes sessions using the Warehouse are terminated

44 / 60

Which of the following terms best describes Snowflake's database architecture?

Shared disk

Columnar shared nothing

Multi-cluster, shared data

Cloud-native shared memory

45 / 60

Which of the following objects is not covered by Time Travel?

Tables

Stages

Schemas

Databases

46 / 60

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

ACCOUNTADMIN

SECURITYADMIN, ACCOUNTADMIN

SECURITYADMIN, ACCOUNTADMIN, SYSADMIN

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

47 / 60

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes

24 hours

14 days

30 days

1 year

48 / 60

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling up

Scaling max

Scaling out

Scaling rhythmically

49 / 60

Which item in the Data Warehouse migration process does not apply in Snowflake?

Migrate Users

Migrate Indexes

Migrate Schemas

Build the Data Pipeline

50 / 60

What is the recommended Snowflake data type to store semi-structured data like JSON?

RAW

LOB

VARIANT

VARCHAR

51 / 60

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Premier

Standard

Enterprise

Business Critical Edition

52 / 60

Which type of table corresponds to a single Snowflake session?

Transient

Temporary

Provisional

Permanent

53 / 60

In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Database Layer

Compute Layer

Cloud Services Layer

54 / 60

Which interfaces can be used to create and/or manage Virtual Warehouses?

SQL commands

Data integration tools

The Snowflake Web Interface (UI)

All of the above

55 / 60

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

USE WAREHOUSE <<warehouse name>>;

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

56 / 60

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

Resource Monitor

Account Usage Tracking

Warehouse Limit Parameter

Credit Consumption Tracker

57 / 60

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate more users

To accommodate more queries

To accommodate fluctuations in workload

To accommodate a more complex workload

58 / 60

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

Key partitions

Clustering keys

Micro-partitions

Clustered partitions

59 / 60

Which of the following roles is recommended to be used to create and manage users and roles?

PUBLIC

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

60 / 60

Account-level storage usage can be monitored via:

The Snowflake Web Interface (UI) in the Databases section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

The Snowflake Web Interface (UI) in the Account -> Billing & Usage section

Your score is

The average score is 70%

By Wordpress Quiz plugin

Free SnowPro-Core Practice Exam – Updated 2025

Study Smarter for the SnowPro-Core Exam with Our Free and Accurate SnowPro-Core Exam Questions – Updated for 2025.

Disclaimer

[email protected]

Helpful links

top Vendors

Contact Us

[email protected]

FLASH OFFER

avail $6 DISCOUNT on YOUR PURCHASE