Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

QUESTION: 456

What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

1 minute
5 minutes
10 minutes
15 minutes

Answer(s): C

QUESTION: 457

Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued.

What is the recommended way to resolve this issue?

Reduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.
Reduce the warehouse AUTO_SUSPEND parameter.
Increase the warehouse MAX_CONCURRENCY_LIMIT parameter.
Increase the warehouse MAX_CLUSTER_COUNT parameter.

Answer(s): D

Show Answer Next Question

QUESTION: 458

Which data types are valid in Snowflake? (Choose two.)

BLOB
Geography
JSON
CLOB
Variant

Answer(s): B,E

Show Answer Next Question

QUESTION: 459

What happens when the size of a virtual warehouse is changed?

Queries that are running on the current warehouse configuration are not impacted.
Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.
Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.
Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.

Answer(s): A

Show Answer Next Question