Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

• A.Information Schema -> TABLE_FUNCTION
• B.SHOW TABLES;
• C.SHOW STORAGE BY TABLE;
• D.Information Schema -> TABLE_STORAGE_METRICS
• E.Information Schema -> TABLE_HISTORY

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A.The primary cluster in the virtual warehouse
• B.The entire virtual warehouse
• C.The database in which the virtual warehouse resides
• D.The Queries currently being run on the virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A.Table
• B.Internal stage
• C.Role
• D.User
• E.View
• F.Schema

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible to load data into Snowflake without creating a named File Format object.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *