Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

A.

Warehouses that are multi-cluster can have nodes of different sizes.

B.

Warehouses can be started and stopped at any time.

C.

Warehouses can be resized at any time, even while running.

D.

Warehouses are billed on a per-minute usage basis.

E.

Warehouses can only be used for querying and cannot be used for data loading.

What happens when a Snowflake user changes the data retention period at the schema level?

A.

All child objects will retain data for the new retention period.

B.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

C.

All child objects with an explicit retention period will be overridden with the new retention period.

D.

All explicit child object retention periods will remain unchanged.

Which commands are restricted in owner ' s rights stored procedures? (Select TWO).

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Which Snowflake table objects can be shared with other accounts? (Select TWO).

A.

Temporary tables

B.

Permanent tables

C.

Transient tables

D.

External tables

E.

User-Defined Table Functions (UDTFs)