ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 14

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
Which minimum Snowflake edition allows for a dedicated metadata store?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?

Question 131

Report
Export
Collapse

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A.
Compute layer
A.
Compute layer
Answers
B.
Storage layer
B.
Storage layer
Answers
C.
Cloud infrastructure layer
C.
Cloud infrastructure layer
Answers
D.
Cloud services layer
D.
Cloud services layer
Answers
Suggested answer: A

Explanation:

For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer

https://www.projectpro.io/article/snowflake-architecture-what-does-snowflakedo/556#:~:text=Query%20Processing%20Layer%2FCompute%20Layer,run%20queries%20in%20this%20layer.

Question 132

Report
Export
Collapse

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

A.
Standard
A.
Standard
Answers
B.
Premium
B.
Premium
Answers
C.
Enterprise
C.
Enterprise
Answers
D.
Business Critical
D.
Business Critical
Answers
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/user-guide/privatelink-azure.html

Question 133

Report
Export
Collapse

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A.
Bytes scanned
A.
Bytes scanned
Answers
B.
Bytes sent over the network
B.
Bytes sent over the network
Answers
C.
Number of partitions scanned
C.
Number of partitions scanned
Answers
D.
Percentage scanned from cache
D.
Percentage scanned from cache
Answers
E.
External bytes scanned
E.
External bytes scanned
Answers
Suggested answer: A, C

Question 134

Report
Export
Collapse

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

A.
ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
A.
ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
Answers
B.
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
B.
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answers
C.
GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
C.
GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
Answers
D.
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
D.
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answers
Suggested answer: B

Question 135

Report
Export
Collapse

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A.
A single join node uses more than 50% of the query time
A.
A single join node uses more than 50% of the query time
Answers
B.
Partitions scanned is equal to partitions total
B.
Partitions scanned is equal to partitions total
Answers
C.
An AggregateOperacor node is present
C.
An AggregateOperacor node is present
Answers
D.
The query is spilling to remote storage
D.
The query is spilling to remote storage
Answers
Suggested answer: D

Question 136

Report
Export
Collapse

Which stage type can be altered and dropped?

A.
Database stage
A.
Database stage
Answers
B.
External stage
B.
External stage
Answers
C.
Table stage
C.
Table stage
Answers
D.
User stage
D.
User stage
Answers
Suggested answer: C

Explanation:

https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#tablestages

Question 137

Report
Export
Collapse

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

A.
SnowSQL
A.
SnowSQL
Answers
B.
Snowflake classic web interface (Ul)
B.
Snowflake classic web interface (Ul)
Answers
C.
Snowsight
C.
Snowsight
Answers
D.
.NET driver
D.
.NET driver
Answers
Suggested answer: A

Explanation:

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

Question 138

Report
Export
Collapse

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

A.
A compressed file size greater than 100 MB, and up to 250 MB
A.
A compressed file size greater than 100 MB, and up to 250 MB
Answers
B.
A compressed file size greater than 100 GB, and up to 250 GB
B.
A compressed file size greater than 100 GB, and up to 250 GB
Answers
C.
A compressed file size greater than 10 MB, and up to 100 MB
C.
A compressed file size greater than 10 MB, and up to 100 MB
Answers
D.
A compressed file size greater than 1 GB, and up to 2 GB
D.
A compressed file size greater than 1 GB, and up to 2 GB
Answers
Suggested answer: A

Explanation:

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

Question 139

Report
Export
Collapse

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

A.
Compute resources
A.
Compute resources
Answers
B.
Query execution
B.
Query execution
Answers
C.
Authentication
C.
Authentication
Answers
D.
Data storage
D.
Data storage
Answers
E.
Metadata
E.
Metadata
Answers
Suggested answer: C, E

Explanation:

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

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

Question 140

Report
Export
Collapse

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

A.
Snowflake parameters
A.
Snowflake parameters
Answers
B.
Micro-partitions
B.
Micro-partitions
Answers
C.
Query history
C.
Query history
Answers
D.
Persisted query results
D.
Persisted query results
Answers
E.
Standard and secure view results
E.
Standard and secure view results
Answers
Suggested answer: B, D
Total 330 questions
Go to page: of 33
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms