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

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

A.

Database

B.

Tables

C.

Warehouses

D.

Worksheets

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are
primarily scaling for improved:
Select one.

A.

Concurrency

B.

Performance

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A.

True

B.

False

True or False: An active warehouse is required to run a COPY INTO statement.

A.

True

B.

False

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

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

A.

True

B.

False

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

A.

True

B.

False

Which of the following DML commands isn’t supported by Snowflake?

A.

UPSERT

B.

MERGE

C.

UPDATE

D.

TRUNCATE TABLE