Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

• A.Pipe
• B.Stream
• C.External stage
• D.Task

Comment: *

Name: *

Email: *

Verification: *

How many resource monitors can be assigned at the account level?

• A.1
• B.2
• C.3
• D.4

Comment: *

Name: *

Email: *

Verification: *

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

• A.Cluster a table.
• B.Create a view.
• C.Enable Time Travel.
• D.Enable the search optimization service.
• E.Index a table.

Comment: *

Name: *

Email: *

Verification: *

What is a characteristic of the Snowflake Query Profile?

• A.It can provide statistics on a maximum number of 100 queries per week.
• B.It provides a graphic representation of the main components of the query processing.
• C.It provides detailed statistics about which queries are using the greatest number of compute resources.
• D.It can be used by third-party software using the Query Profile API.

Comment: *

Name: *

Email: *

Verification: *

What can be used to view warehouse usage over time? (Select Two).

• A.The load HISTORY view
• B.The Query history view
• C.The show warehouses command
• D.The WAREHOUSE_METERING__HISTORY View
• E.The billing and usage tab in the Snowflake web Ul

Comment: *

Name: *

Email: *

Verification: *