What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

• A.Warehouses that are multi-cluster can have nodes of different sizes.
• B.Warehouses can be started and stopped at any time.
• C.Warehouses can be resized at any time, even while running.
• D.Warehouses are billed on a per-minute usage basis.
• E.Warehouses can only be used for querying and cannot be used for data loading.

Comment: *

Name: *

Email: *

Verification: *

How can a user get the MOST detailed information about individual table storage details in Snowflake?

• A.SHOW TABLES command
• B.SHOW EXTERNAL TABLES command
• C.TABLES view
• D.TABLE STORAGE METRICS view

Comment: *

Name: *

Email: *

Verification: *

True or False: A Virtual Warehouse can be resized while suspended.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

• A.The column name and element names are both case-sensitive.
• B.The column name and element names are both case-insensitive.
• C.The column name is case-sensitive but element names are case-insensitive.
• D.The column name is case-insensitive but element names are case-sensitive.

Comment: *

Name: *

Email: *

Verification: *

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

• A.Bytes spilled to local cache.
• B.Bytes spilled to local storage.
• C.Bytes spilled to remote cache.
• D.Bytes spilled to remote storage.
• E.Bytes spilled to remote metastore.

Comment: *

Name: *

Email: *

Verification: *