A.To accommodate more queries

B.To accommodate more users

C.To accommodate fluctuations in workload

D.To accommodate a more complex workload

A.User-Defined Functions (UDFs)

B.Materialized views

C.Secure views

D.External tables

A.1 second

B.60 minutes

C.60 seconds

D.5 minutes

A.The return of micro-partitions values that overlap with each other to reduce a query's runtime.

B.A service that is handled by the Snowflake Cloud Services layer to optimize caching.

C.The ability to allow the result of a query to be accessed as if it were a table.

D.The filtering or disregarding of micro-partitions that are not needed to return a query.

A.SHOW TABLES;

B.SHOW STORAGE BY TABLE;

C.Information Schema -> TABLE_HISTORY

D.Information Schema -> TABLE_STORAGE_METRICS

E.Information Schema -> TABLE_FUNCTION