Question 1

Which Snowflake objects use storage? (Select TWO)

Options :

A : Regular table

B : Regular view

C : Cached query result

D : Materialized view

E : External table

Answer: A,D

Question 2

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 3

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

Options :

A : A defined level of access to an object

B : An entity in which access can be granted

C : Each object has an owner, who can in turn grail access to that object.

D : Access privileges are assigned to roles. which are in turn assigned to use's

Answer: D

Question 4

When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

Options :

A :

B :

C :

D :

Answer: B

Question 5

Which Snowflake technique can be used to improve the performance of a query?

Options :

A : Clustering

B : Indexing

C : Fragmenting

D : Using INDEX__HINTS

Answer: A

Higher Test Marks with Free Online SnowPro-Core Exam Practice

Buying Options: