SnowPro-Core Snowflake Exam Questions and Free Practice Test

- (Exam Topic 1)
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A. True

B. False

Correct Answer:B
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

- (Exam Topic 1)
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

A. Temporary Tables

B. Transient Tables

C. Provisional Tables

D. Permanent Tables

Correct Answer:AB
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

- (Exam Topic 3)
Which statement is true about running tasks in Snowflake?

A. A task can be called using a CALL statement to run a set of predefined SQL commands.

B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

C. A task allows a user to execute a set of SQL commands on a predefined schedule.

D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer:C

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

A. Standard

B. Premier

C. Enterprise

D. Business Critical Edition

Correct Answer:C
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

- (Exam Topic 3)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A. INSERT

B. PUT

C. GET

D. COPY

Correct Answer:D

- (Exam Topic 1)
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

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

START SnowPro-Core EXAM