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

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A.

True

B.

False

True or False: During data unloading, only JSON and CSV files can be compressed.

A.

True

B.

False

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A.

True

B.

False

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A.

True

B.

False

When can a Virtual Warehouse start running queries?

A.

12am-5am

B.

Only during administrator defined time slots

C.

When its provisioning is complete

D.

After replication

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

A.

True

B.

False

Which of the following terms best describes Snowflake’s database architecture?

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

A.

Is available to all Snowflake Editions

B.

Is only available to customers with Business Critical Edition

C.

Restricts or enables access to specific IP addresses

D.

Is activated using an “ALTER DATABASE” command

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);

Snowflake is designed for which type of workloads? (Choose two.)

A.

OLAP (Analytics) workloads

B.

OLTP (Transactional) workloads

C.

Concurrent workloads

D.

On-premise workloads