QUESTION: 133

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

Bytes scanned
Bytes sent over the network
Number of partitions scanned
Percentage scanned from cache
External bytes scanned

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 134

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?

ALLOW RESIZE ON WAREHOUSE MKTG WH TO USER MKTG LEAD;
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
GRANT MODIFY ON WAREHOUSE MKTG WH TO USER MKTG LEAD;
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Answer(s): B

Reveal Solution Next Question

QUESTION: 135

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

A single join node uses more than 50% of the query time
Partitions scanned is equal to partitions total
An AggregateOperacor node is present
The query is spilling to remote storage

Answer(s): D

Reveal Solution Next Question

QUESTION: 136

Which stage type can be altered and dropped?

Database stage
External stage
Table stage
User stage

Answer(s): C

Reference:

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

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 35)

QUESTION: 133

QUESTION: 134

QUESTION: 135

QUESTION: 136

Reference:

COF-R02 Discussions & Posts