How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

• A.Set the minimum and maximum clusters to autoscale
• B.Use the economy warehouse scaling policy
• C.Use the standard warehouse scaling policy
• D.Configure the warehouse to a size larger than generally required

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: *

Which of the following can be executed/called with Snowpipe?

• A.A User Defined Function (UDF)
• B.A single insert__into statement
• C.A stored procedure
• D.A single copy_into statement

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake charges additional fees to Data providers for each share they create.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

• A.Option B
• B.Option A
• C.Option D
• D.Option C

Comment: *

Name: *

Email: *

Verification: *