What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

• A.The ability to scale up warehouses
• B.The ability to resize warehouses
• C.The use of warehouse indexing
• D.The use of warehouse auto scaling
• E.Use of multi-clustered warehouses

Comment: *

Name: *

Email: *

Verification: *

What is the recommended Snowflake data type to store semi-structured data like JSON?

• A.VARCHAR
• B.RAW
• C.LOB
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *

What happens when a cloned table is replicated to a secondary database? (Select TWO)

• A.A read-only copy of the cloned tables is stored.
• B.The replication will not be successful.
• C.The physical data is replicated
• D.Additional costs for storage are charged to a secondary account
• E.Metadata pointers to cloned tables are replicated

Comment: *

Name: *

Email: *

Verification: *

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

• A.Partitions total
• B.Partitions scanned
• C.Bytes sent over network
• D.Percentage scanned from cache
• E.Bytes spilled to local storage

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.False
• B.True

Comment: *

Name: *

Email: *

Verification: *