True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which command is used to unload data from a Snowflake table into a file in a stage?

• A.COPY INTO
• B.GET
• C.WRITE
• D.EXTRACT INTO

Comment: *

Name: *

Email: *

Verification: *

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

• A.Query execution
• B.Resource management
• C.Physical storage of micro-partitions
• D.Authentication
• E.Virtual warehouse caching
• F.Query parsing and optimization

Comment: *

Name: *

Email: *

Verification: *

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

• A.Query processing
• B.Authentication and access control
• C.Metadata management
• D.Local disk caching
• E.Database storage

Comment: *

Name: *

Email: *

Verification: *

A materialized view should be created when which of the following occurs? (Choose two.)

• A.The query is highly optimized and does not consume many compute resources.
• B.The results of the query do not change often and are used frequently.
• C.The query consumes many compute resources every time it runs.
• D.There is minimal cost associated with running the query.
• E.The base table gets updated frequently.

Comment: *

Name: *

Email: *

Verification: *