Question 1

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options :

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 2

Which cache type is used to cache data output from SQL queries?

Options :

A : Metadata cache

B : Result cache

C : Remote cache

D : Local file cache

Answer: B

Question 3

What happens when a virtual warehouse is resized?

Options :

A : When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B : When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C : The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D : Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Question 4

What features does Snowflake Time Travel enable?

Options :

A : Querying data-related objects that were created within the past 365 days

B : Restoring data-related objects that have been deleted within the past 90 days

C : Conducting point-in-time analysis for Bl reporting

D : Analyzing data usage/manipulation over all periods of time

Answer: B

Question 5

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

Options :

A : Schema Stage

B : User Stage

C : Database Stage

D : Table Stage

E : External Named Stage

F : Internal Named Stage

Answer: A