Question 1

Multiple choice

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Show answer

Correct answers: B, D

Explanation

References:
https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

Question 2

Multiple choice

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:

A.

Temporary Tables

B.

Transient Tables

C.

Provisional Tables

D.

Permanent Tables

Show answer

Correct answers: A, B

Explanation

References:
https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

Question 3

Multiple choice

When loading data into Snowflake, the COPY command supports:

A.

Joins

B.

Fitters

C.

Data type conversions

D.

Column reordering

E.

Aggregates

Show answer

Correct answers: C, D

Question 4

Single choice

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

A.

Tables

B.

Schemas

C.

Databases

D.

Stages

Show answer

Correct answer: D

Explanation

References:
https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question 5

Single choice

What is the minimum duration charged when starting a virtual warehouse?

A.

1 second

B.

1 minute

C.

1 hour

D.

1 day

Show answer

Correct answer: B

Question 6

Single choice

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

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Show answer

Correct answer: C

Explanation

https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

Question 7

Multiple choice

Which of the following are options when creating a Virtual Warehouse?

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Show answer

Correct answers: A, B

Question 8

Multiple choice

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

A.

Java

B.

JavaScript

C.

SQL

D.

Python

Show answer

Correct answers: A, B, C, D

Explanation

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

Question 9

Single choice

Which statement best describes Snowflake tables?

A.

Snowflake tables are logical representations of underlying physical data

B.

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

C.

Snowflake tables require that clustering keys be defined to perform optimally

D.

Snowflake tables are owned by a user

Show answer

Correct answer: A

Explanation

References:
https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html

Question 10

Single choice

When active, a pipe requires a dedicated Virtual Warehouse to execute.

A.

True

B.

False

Show answer

Correct answer: B

Showing 10 of 1,700 questions · Unlock the full set