Question 1

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options :

A : Management of metadata

B : Computing the data

C : Maintaining Availability Zones

D : Infrastructure security

E : Parsing and optimizing queries

Answer: A,E

Question 2

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options :

A : True

B : False

Answer: A

Question 3

When unloading to a stage, which of the following is a recommended practice or approach?

Options :

A : Set SINGLE: = true for larger files

B : Use OBJECT_CONSTRUCT ( * ) when using Parquet

C : Avoid the use of the CAST function

D : Define an individual file format

Answer: D

Question 4

While unloading data into a stage, how can the user ensure that the output will be a single file?

Options :

A : Use the copy option files=single.

B : Use the COPY Option SINGLE=TRUE .

C : Use the get option SINGLE-TRUE.

D : Use the GET option FILES-SINGLE.

Answer: B

Question 5

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data. How does Snowflake recommend resolving this issue?

Options :

A : Scale up the existing warehouse.

B : Create separate warehouses for each user.

C : Create separate warehouses for each workload.

D : Stop loading and querying data at the same time.

Answer: C