Question 1

Which Snowflake object will consume credits during automatic background maintenance?

Options :

A : View

B : Table

C : External table

D : Materialized view

Answer: C

Question 2

A virtual warehouse is created using the following command:Create warehouse my_WH withwarehouse_size = MEDIUMmin_cluster_count = 1max_cluster_count = 1auto_suspend = 60auto_resume = true;The image below is a graphical representation of the warehouse utilization across two days.What action should be taken to address this situation?

Options :

A : Increase the warehouse size from Medium to 2XL.

B : Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C : Configure the warehouse to a multi-cluster warehouse.

D : Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer: C

Question 3

What is the default File Format used in the COPY command if one is not specified?

Options :

A : CSV

B : JSON

C : Parquet

D : XML

Answer: A

Question 4

True or False: Fail-safe can be disabled within a Snowflake account.

Options :

A : True

B : False

Answer: B

Question 5

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

Options :

A : ARRAY

B : OBJECT

C : TEXT

D : VARIANT

Answer: D

Free SnowPro-Core Mock Exam – Practice Online Confidently

Buying Options: