SnowPro-Core Practice Test Questions

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

A.

Concurrency

B.

Performance

B.

Performance

Reference: https://docs.snowflake.com/en/user-guide/warehousesconsiderations.
html#warehouse-resizing-improves-performance

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

A.

True

B.

False

A.

True

Reference: https://acrotrend.com/snowflake-data-sharing/

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

A.

True

B.

False

A.

True

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

A.

Snowflake tables are logical representations of underlying physical data

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

A.

True

B.

False

B.

False

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

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

B.

Simplicity

D.

Concurrency

E.

Performance

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

A.

True

B.

False

B.

False

Reference: https://docs.snowflake.com/en/sql-reference/constraints-overview.html

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

A.

UPSERT

B.

MERGE

C.

UPDATE

D.

TRUNCATE TABLE

A.

UPSERT

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

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT
statement.

A.

True

B.

False

A.

True

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

Which of the following statements would be used to export/unload data from Snowflake?

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

A.

COPY INTO @stage

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

What parameter controls if the Virtual warehouse starts immediately after the CREATE
WAREHOUSE statement?
Select one.

A.

INITTIALLY_SUSPENDED = TRUE/FALSE

B.

START_AFTCR_CREATE = TRUE/FALSE

C.

START_TTIME = 60 // (seconds from now)

D.

START.TIME = CURRENT.DATE()

A.

INITTIALLY_SUSPENDED = TRUE/FALSE

Which of the following are examples of operations that require a Virtual Warehouse to
complete, assuming no quires have been executed previously?
Choose 3 answers

A.

MIN(< < column value>>)

B.

COPY

C.

SUM(<< column value >>)

D.

UPDATE

B.

COPY

C.

SUM(<< column value >>)

D.

UPDATE