SnowPro Core Certification SnowPro-Core Release Date

SnowPro Core Certification Exam Questions and Answers

Question 129

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

Scaling out adds clusters of varying sizes to a virtual warehouse.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Question 130

Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <>;

SET WAREHOUSE = <>;

USE WAREHOUSE <>;

USE VIRTUAL_WAREHOUSE <>;

Question 131

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Materialized view

Sequence

Secure view

Transient table

Clustered table

Question 132

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Database replication and failover

Automated index management

Customer managed keys (Tri-secret secure)

Extended time travel

Native support for geospatial data