Question 1

Which of the following statements are true about Zero-Copy Cloning in Snowflake? (Select TWO)

Options :

A : It requires significant additional storage.

B : It is immediate and metadata-only operation.

C : It duplicates the underlying data storage.

D : It creates a writable copy of an object.

Answer: B,D

Question 2

What filter can be used when searching for data products on the Snowflake Marketplace?

Options :

A : Size

B : Compatibility

C : Price

D : Performance

Answer: C

Question 3

What is the LIST command used for in Snowflake?

Options :

A : Lists all the users assigned to a given role.

B : Lists all the files in a given stage.

C : Lists all the tables in a specific schema.

D : Lists all the privileges granted on a specific object.

Answer: B

Question 4

Which options are used in Snowflake notebooks for querying data? (Choose any 3 options)

Options :

A : Python

B : SQL

C : Markup

D : Markdown

Answer: A,B,D

Question 5

Which command will create a named internal stage?

Options :

A : CREATE @STAGE

B : CREATE NAMED STAGE

C : CREATE STAGE

D : CREATE INTERNAL STAGE

Answer: C