Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A.Materialized views
• B.Sequences
• C.Procedures
• D.Tables
• E.Secure User Defined Functions (UDFs)

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about running tasks in Snowflake?

• A.A task can be called using a CALL statement to run a set of predefined SQL commands.
• B.A task can be executed using a SELECT statement to run a predefined SQL command.
• C.A task allows a user to execute a set of SQL commands on a predefined schedule.
• D.A task allows a user to execute a single SQL statement/command using a predefined schedule.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
• B.Configure the warehouse to a multi-cluster warehouse.
• C.Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
• D.Increase the warehouse size from Medium to 2XL.

Comment: *

Name: *

Email: *

Verification: *

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

• A.Bytes sent over network
• B.Bytes spilled to local storage
• C.Partitions scanned
• D.Percentage scanned from cache
• E.Partitions total

Comment: *

Name: *

Email: *

Verification: *

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

• A.60 minutes
• B.24 hours
• C.14 days
• D.30 days
• E.1 year

Comment: *

Name: *

Email: *

Verification: *