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: *

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

• A.An explain plan will handle queries with temporary tables and the query profiler will not.
• B.An explain plan can be used to conduct performance analysis without executing a query.
• C.An explain plan's output will display automatic data skew optimization information.
• D.The explain plan output is available graphically.

Comment: *

Name: *

Email: *

Verification: *

True or False: You can define multiple columns within a clustering key on a table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

True or False: Users are able to see the result sets of queries executed by other users that share their same role.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

• A.Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
• B.Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
• C.Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
• D.Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
• E.Scaling out adds clusters of varying sizes to a virtual warehouse.
• F.Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Comment: *

Name: *

Email: *

Verification: *