A.Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

B.Scaling out adds clusters of varying sizes to a virtual warehouse.

C.Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

E.Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

A.SELECT ORDER_AMT * ORDER_QTY FROM SALES;

B.SELECT AVG(ORDER_QTY) FROM SALES;

C.SELECT MIN(ORDER_AMT) FROM SALES;

D.SELECT SUM (ORDER_AMT) FROM SALES;

A.A Materialized View cannot support any aggregate functions

B.A Materialized View can only reference up to two tables

C.A Materialized View cannot be joined with other tables

D.A Materialized View cannot be defined with a JOIN

A.Set the minimum clusters and maximum clusters settings to different values.

B.Configure the maximum clusters setting to "Maximum."

C.Set the minimum Clusters and maximum Clusters settings to the same value.

D.Turn on the additional clusters manually after starting the warehouse.

A.CSV

B.JSON

C.Parquet

D.XML