QUESTION: 137

Which command can be used to stage local files from which Snowflake interface?

SnowSQL
Snowflake classic web interface (Ul)
Snowsight
.NET driver

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/snowsql-use.html

Reveal Solution Next Question

QUESTION: 138

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

Reference:

https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

Reveal Solution Next Question

QUESTION: 139

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources
Query execution
Authentication
Data storage
Metadata

Answer(s): C,E

Explanation:

The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
Authentication
Infrastructure management
Metadata management
Query parsing and optimization
Access control

Reference:

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Reveal Solution Next Question

QUESTION: 140

What data is stored in the Snowflake storage layer? (Select TWO).

Snowflake parameters
Micro-partitions
Query history
Persisted query results
Standard and secure view results

Answer(s): B,D

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 35)

QUESTION: 137

Reference:

QUESTION: 138

Reference:

QUESTION: 139

Explanation:

Reference:

QUESTION: 140