Snowflake COF-C02 SnowPro Core Certification Exam Online Training
Snowflake COF-C02 Online Training
The questions for COF-C02 were last updated at Nov 23,2024.
- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Nov 23,2024
How long is Snowpipe data load history retained?
- A . As configured in the create pipe settings
- B . Until the pipe is dropped
- C . 64 days
- D . 14 days
In which use cases does Snowflake apply egress charges?
- A . Data sharing within a specific region
- B . Query result retrieval
- C . Database replication
- D . Loading data into Snowflake
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A . ROLES
- B . POLICY_REFERENCES
- C . QUERY_HISTORY
- D . RESOURCE_MONIT ORS
- E . ACCESS_HISTORY
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A . Compute layer
- B . Storage layer
- C . Cloud infrastructure layer
- D . Cloud services layer
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
- B . Premium
- C . Enterprise
- D . Business Critical
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
- B . Bytes sent over the network
- C . Number of partitions scanned
- D . Percentage scanned from cache
- E . External bytes scanned
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;
- B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
- C . GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- D . GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
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
- B . Partitions scanned is equal to partitions total
- C . An AggregateOperacor node is present
- D . The query is spilling to remote storage
Which stage type can be altered and dropped?
- A . Database stage
- B . External stage
- C . Table stage
- D . User stage
Which command can be used to stage local files from which Snowflake interface?
- A . SnowSQL
- B . Snowflake classic web interface (Ul)
- C . Snowsight
- D . .NET driver
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
