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
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A . The ability to scale up warehouses
- B . The use of warehouse auto scaling
- C . The ability to resize warehouses
- D . Use of multi-clustered warehouses
- E . The use of warehouse indexing
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
- A . Use multi-clustered warehousing to scale out warehouse capacity.
- B . Scale up the warehouse size to allow Queries to execute faster.
- C . Stop and start the warehouse to clear the queued queries
- D . Migrate some queries to a new warehouse to reduce load
- E . Limit user access to the warehouse so fewer queries are run against it.
Which of the following objects can be shared through secure data sharing?
- A . Masking policy
- B . Stored procedure
- C . Task
- D . External table
Which of the following commands cannot be used within a reader account?
- A . CREATE SHARE
- B . ALTER WAREHOUSE
- C . DROP ROLE
- D . SHOW SCHEMAS
- E . DESCRBE TABLE
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 staged?
- A . list @mytable;
- B . list @%raytable;
- C . list @ %m.ystage;
- D . list @mystage;
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- A . Customer-managed encryption keys through Tri-Secret Secure
- B . Automatic encryption of all data
- C . Up to 90 days of data recovery through Time Travel
- D . Object-level access control
- E . Column-level security to apply data masking policies to tables and views
Which command is used to unload data from a Snowflake table into a file in a stage?
- A . COPY INTO
- B . GET
- C . WRITE
- D . EXTRACT INTO
How often are encryption keys automatically rotated by Snowflake?
- A . 30 Days
- B . 60 Days
- C . 90 Days
- D . 365 Days
What are value types that a VARIANT column can store? (Select TWO)
- A . STRUCT
- B . OBJECT
- C . BINARY
- D . ARRAY
- E . CLOB
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
