Helping Hand Questions for COF-C02

SnowPro Core Certification Exam Questions and Answers

Question 41

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

Configure the maximum clusters setting to "Maximum."

Turn on the additional clusters manually after starting the warehouse.

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

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

Question 42

Which Snowflake tool would be BEST to troubleshoot network connectivity?

SnowCLI

SnowUI

SnowSQL

SnowCD

Question 43

Which statement describes pruning?

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

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

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

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

Question 44

Which file format will keep floating-point numbers from being truncated when data is unloaded?

CSV

JSON

ORC

Parquet