For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

• A.CHECK_OPTION
• B.IS_SECURE
• C.TABLE_NAME
• D.IS_UPDATEABLE

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes a characteristic of a materialized view?

• A.Data accessed through materialized views can be stale.
• B.Materialized view refreshes need to be maintained by the user.
• C.Querying a materialized view is slower than executing a query against the base table of the view.
• D.A materialized view can query only a single table.

Comment: *

Name: *

Email: *

Verification: *

How would a user run a multi-cluster warehouse in maximized mode?

• A.Configure the maximum clusters setting to "Maximum."
• B.Set the minimum clusters and maximum clusters settings to different values.
• C.Set the minimum Clusters and maximum Clusters settings to the same value.
• D.Turn on the additional clusters manually after starting the warehouse.

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?

• A.list @ %m.ystage;
• B.list @%raytable;
• C.list @mystage;
• D.list @mytable;

Comment: *

Name: *

Email: *

Verification: *