COF-C02 Free Practice Test

- (Topic 2)
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

1. A. 30 days
2. B. 7 days
3. C. 48 hours
4. D. 24 hours

Correct Answer: D
For a temporary table, the maximum total Continuous Data Protection (CDP) charges incurred are for the duration of the session in which the table was created, which does not exceed 24 hours2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation2

- (Topic 6)
What kind of authentication do Snowpipe REST endpoints use?

1. A. OAuth
2. B. Key-based
3. C. Username and password
4. D. Single Sign-On (SSO)

Correct Answer: B
Snowpipe uses key-based authentication for its REST endpoints. This involves generating and using a key pair (public and private keys) to securely authenticate API requests.
✑ Generate Key Pair:Generate a public and private key pair.
✑ Register Public Key:Register the public key with the Snowflake user that will be making the API requests.
✑ Authenticate Requests:Use the private key to sign API requests sent to Snowpipe REST endpoints.
References:
✑ Snowflake Documentation: Key Pair Authentication & Key Rotation
✑ Snowflake Documentation: Using Snowpipe REST API

- (Topic 3)
Which SQL command can be used to see the CREATE definition of a masking policy?

1. A. SHOW MASKING POLICIES
2. B. DESCRIBE MASKING POLICY
3. C. GET_DDL
4. D. LIST MASKING POLICIES

Correct Answer: C
The SQL command GET_DDL can be used to retrieve the CREATE definition of a masking policy in Snowflake. This command generates the DDL statement required to recreate the masking policy

- (Topic 3)
What column type does a Kafka connector store formatted information in a single column?

1. A. ARRAY
2. B. OBJECT
3. C. VARCHAR
4. D. VARIANT

Correct Answer: D
The Kafka connector stores formatted information in a single column of type VARIANT. This column type is used to store semi-structured data like JSON or Avro, which allows for flexibility in the data structure

- (Topic 1)
What tasks can be completed using the copy command? (Select TWO)

1. A. Columns can be aggregated
2. B. Columns can be joined with an existing table
3. C. Columns can be reordered
4. D. Columns can be omitted
5. E. Data can be loaded without the need to spin up a virtual warehouse

Correct Answer: CD
The COPY command in Snowflake allows for the reordering of columns as they are loaded into a table, and it also permits the omission of columns from the source file during the load process. This provides flexibility in handling the schema of the data being ingested. References: [COF-C02] SnowPro Core Certification Exam Study Guide