Question 1

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

Options :

A : Binary file in Avro

B : Binary file in Parquet

C : Comma-separated JSON

D : Newline Delimited JSON

E : Plain text file containing XML elements

Answer: B,D

Question 2

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Options :

A :

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B :

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C :

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Answer: A,B

Question 3

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options :

A : MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

B : MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

C : MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

D : MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Answer: C

Question 4

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_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 5

Which objects will incur storage costs associated with Fail-safe?

Options :

A : External tables

B : Permanent tables

C : Data files available in internal stages

D : Data files available in external stages

Answer: D