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

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 are benefits of micro-partitioning? (Select TWO)

• A.Micro-partitions cannot overlap in their range of values
• B.Micro-partitions are immutable objects that support the use of Time Travel.
• C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D.Rows are automatically stored in sorted order within micro-partitions
• E.Micro-partitions can be defined on a schema-by-schema basis

Comment: *

Name: *

Email: *

Verification: *

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

• A.The file will continue to load until all contents arc loaded.
• B.The file loading could be aborted without any portion of the file being committed.
• C.The tile will slop loading and all data up to that point will be committed.
• D.The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

Comment: *

Name: *

Email: *

Verification: *