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
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
- B . A compressed file size greater than 100 GB, and up to 250 GB
- C . A compressed file size greater than 10 MB, and up to 100 MB
- D . A compressed file size greater than 1 GB, and up to 2 GB
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- A . Compute resources
- B . Query execution
- C . Authentication
- D . Data storage
- E . Metadata
What data is stored in the Snowflake storage layer? (Select TWO).
- A . Snowflake parameters
- B . Micro-partitions
- C . Query history
- D . Persisted query results
- E . Standard and secure view results
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
- A . Compute Credits = 50 Credits Cloud Services = 10
- B . Compute Credits = 80 Credits Cloud Services = 5
- C . Compute Credits = 10 Credits Cloud Services = 9
- D . Compute Credits = 120 Credits Cloud Services = 10
- E . Compute Credits = 200 Credits Cloud Services = 26
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)
- A . Data can be filtered by an optional where clause
- B . Incoming data can be joined with other tables
- C . Columns can be reordered
- D . Columns can be omitted
- E . Row level access can be defined
What is a responsibility of Snowflake’s virtual warehouses?
- A . Infrastructure management
- B . Metadata management
- C . Query execution
- D . Query parsing and optimization
- E . Management of the storage layer
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
- A . Execute a COPY command
- B . Updating data
- C . Snowpipe
- D . AUTOMATIC__CLUSTERING
- E . Scaling up a warehouse
What happens when a virtual warehouse is resized?
- A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
- B . When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
- C . The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- D . Users who are trying to use the warehouse will receive an error message until the resizing is complete
A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked data.
Will the developer be able to modify the table to read the masked data?
- A . Yes, because a table owner has full control and can unset masking policies.
- B . Yes, because masking policies only apply to cloned tables.
- C . No, because masking policies must always reference specific access roles.
- D . No, because ownership of a table does not include the ability to change masking policies
Which of the following describes how clustering keys work in Snowflake?
- A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- B . Clustering keys sort the designated columns over time, without blocking DML operations
- C . Clustering keys create a distributed, parallel data structure of pointers to a table’s rows and columns
- D . Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
