Question 1

Which command can be used to stage local files from which Snowflake interface?

Options :

A : SnowSQL

B : Snowflake classic web interface (Ul)

C : Snowsight

D : .NET driver

Answer: A

Question 2

Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).

Options :

A : -1

B : 0

C : 86400

D : 172800

E : NULL

Answer: C,D

Question 3

A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?

Options :

A : File URL

B : Staged URL

C : Scoped URL

D : Pre-signed URL

Answer: D

Question 4

For which use cases is running a virtual warehouse required? (Select TWO).

Options :

A : When creating a table

B : When loading data into a table

C : When unloading data from a table

D : When executing a show command

E : When executing a list command

Answer: B,C

Question 5

What is true about sharing data in Snowflake? (Choose two.)

Options :

A : The Data Consumer pays for data storage as well as for data computing.

B :

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C : A Snowflake account can both provide and consume shared data.

D : The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E : The Data Consumer pays only for compute resources to query the shared data.

Answer: C,E