When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

• A.Use multi-clustered warehousing to scale out warehouse capacity.
• B.Scale up the warehouse size to allow Queries to execute faster.
• C.Limit user access to the warehouse so fewer queries are run against it.
• D.Migrate some queries to a new warehouse to reduce load
• E.Stop and start the warehouse to clear the queued queries

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

True or False: All Snowflake table types include fail-safe storage.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

• A.How often the underlying base table is queried
• B.How often the base table changes
• C.Whether or not it is also a secure view
• D.Whether the materialized view has a cluster key defined
• E.How often the materialized view is queried

Comment: *

Name: *

Email: *

Verification: *

True or False the longer the data retention period, the higher the resulting storage costs.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *