A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A.The primary cluster in the virtual warehouse
• B.The entire virtual warehouse
• C.The database in which the virtual warehouse resides
• D.The Queries currently being run on the virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

• A.Via the Snowflake Web Interface (Ul)
• B.Via the data_share=true parameter
• C.Via SQL commands
• D.Via Virtual Warehouses

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

• A.Growth of storage and compute are tightly coupled together
• B.Storage expands without the requirement to add more compute
• C.Compute can be scaled up or down without the requirement to add more storage
• D.Multiple compute clusters can access stored data without contention

Comment: *

Name: *

Email: *

Verification: *

What is a limitation of a Materialized View?

• A.A Materialized View cannot support any aggregate functions
• B.A Materialized View can only reference up to two tables
• C.A Materialized View cannot be joined with other tables
• D.A Materialized View cannot be defined with a JOIN

Comment: *

Name: *

Email: *

Verification: *

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

• A.CHECK_OPTION
• B.IS_SECURE
• C.IS_UPDATEABLE
• D.TABLE_NAME

Comment: *

Name: *

Email: *

Verification: *