True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A materialized view should be created when which of the following occurs? (Choose two.)

• A.The base table gets updated frequently.
• B.The query is highly optimized and does not consume many compute resources.
• C.The results of the query do not change often and are used frequently.
• D.The query consumes many compute resources every time it runs.
• E.There is minimal cost associated with running the query.

Comment: *

Name: *

Email: *

Verification: *

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

True or false: it is best practice to define a clustering key on every table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *