CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

SnowPro Core Certification SnowPro-Core Release Date

Page: 33 / 45
Total 605 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF

SnowPro Core Certification Exam Questions and Answers

Question 129

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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?

Options:

A.

COPY WAREHOUSE FROM <>;

B.

SET WAREHOUSE = <>;

C.

USE WAREHOUSE <>;

D.

USE VIRTUAL_WAREHOUSE <>;

Question 131

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

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 132

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

Options:

A.

Database replication and failover

B.

Automated index management

C.

Customer managed keys (Tri-secret secure)

D.

Extended time travel

E.

Native support for geospatial data

Page: 33 / 45
Total 605 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF