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

QUESTION: 276

When is the result set cache no longer available? (Choose two.)

When another warehouse is used to execute the query
When another user executes the query
When the underlying data has changed
When the warehouse used to execute the query is suspended
When it has been 24 hours since the last query

Answer(s): C

Show Answer Next Question

QUESTION: 277

What is the recommended file sizing for data loading using Snowpipe?

A compressed file size greater than 100 MB, and up to 250 MB
A compressed file size greater than 100 GB, and up to 250 GB
A compressed file size greater than 10 MB, and up to 100 MB
A compressed file size greater than 1 GB, and up to 2 GB

Answer(s): A

Show Answer Next Question

QUESTION: 278

Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Choose three.)

Snowflake data and services are deployed in a single availability zone within a cloud provider’s region.
Snowflake data and services are available in a single cloud provider and a single region; the use of multiple cloud providers is not supported.
Snowflake can be deployed in a customer’s private cloud using the customer’s own compute and storage resources for Snowflake compute and storage.
Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage.
All three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform.
Snowflake data and services are deployed in at least three availability zones within a cloud provider’s region.

Answer(s): D,E,F

Show Answer Next Question

QUESTION: 279

A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the stage?