SnowPro-Core Practice Test Questions

True or False: You can resize a Virtual Warehouse while queries are running.

A.

True

B.

False

A.

True

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

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

A.

True

B.

False

A.

True

Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-intosnowflake/

Which of the following languages can be used to implement Snowflake User Defined
Functions (UDFs)?
Choose 2 answers

A.

Java

B.

JavaScript

C.

SQL

D.

Python

B.

JavaScript

C.

SQL

Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

What services does Snowflake automatically provide for customer that they may have been
responsible for with their on premise system? Select all the below that apply.

A.

Installing and configuring hardware

B.

Patching software

C.

Physical security

D.

Maintaining metadata and statists

A.

Installing and configuring hardware

B.

Patching software

D.

Maintaining metadata and statists

True or False: A third-party tool that supports standard JDBC or ODBC but has no
Snowflake-specific driver will be unable to connect to Snowflake.

A.

True

B.

False

B.

False

Reference: https://docs.snowflake.com/en/user-guide-connecting.html

A role is created and owns 2 tables. This role is then dropped. Who will now own the two
tables?

A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

D.

The assumed role that dropped the role

Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

True or False: Micro-partition metadata enables some operations to be completed without
requiring Compute.

A.

True

B.

False

A.

True

Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Which statement best describes '' clustering''?

A.

Clustering represents the way data is grouped together and stored within snowflake's
micro-partitions

B.

The database administrator must define the clustering methodology for each Snowflake
table.

C.

The clustering key must be included on the COPV command when loading data into
Snowflake.

D.

Clustering can be disabled within a Snowflake account.

A.

Clustering represents the way data is grouped together and stored within snowflake's
micro-partitions

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

True or False: It is possible to load data into Snowflake without creating a named File
Format object.

A.

True

B.

False

A.

True

Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-

True or False: Fail-safe can be disabled within a Snowflake account.

A.

True

B.

False

A.

True

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

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

A.

The Snowflake Web Interface (UI)

B.

SQL commands

C.

Data integration tools

D.

All of the above

D.

All of the above

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

On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

A.

Amazon Web Services

B.

Private Virtual Cloud

C.

Oracle Cloud

D.

Microsoft Azure Cloud

A.

Amazon Web Services

D.

Microsoft Azure Cloud