True or False: Snowflake charges a premium for storing semi-structured data.

A.

True

B.

False

True or False: You can define multiple columns within a clustering key on a table.

A.

True

B.

False

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse
is started.

A.

True

B.

False

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A.

Customers can change the size of the Warehouse after creation

B.

A Warehouse can be resized while running

C.

A Warehouse can be configured to suspend after a period of inactivity

D.

A Warehouse can be configured to auto-resume when new queries are submitted

Which of the following statements is true of zero-copy cloning?

A.

Zero-copy clones objects inherit

B.

All zero-copy clone objects inherit the privileges of their original objects

C.

Zero-copy coning is licensed as an additional Snowflake feature

D.

At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

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

A.

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

B.

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

C.

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

D.

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

Which of the following statements is true of Snowflake?

A.

It was built specifically for the cloud

B.

It was built as an on-premises solution and then ported to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on
premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

The Information Schema and Account Usage Share provide storage information for which
of the following objects? (Choose three.)

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

A.

True

B.

False

Which formats are supported for unloading data from Snowflake?
Choose 2 answers

A.

Delimited (CSV, TSV, etc.)

B.

Avro

C.

JSON

D.

ORC