Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1001:

  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

  Correct Answer: B

• Question 1002:

  What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  A. Data is hashed by the cluster key to facilitate fast searches for common data values

  B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

  C. Smaller micro-partitions are created for common data values to allow for more parallelism

  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

  Correct Answer: D

• Question 1003:

  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

  Correct Answer: C

  nowflake charges a per-byte fee for data egress when users transfer data from a Snowflake account into a different region on the same cloud platform or into a completely different cloud platform. Data transfers within the same region are free.

• Question 1004:

  What is the default File Format used in the COPY command if one is not specified?

  A. CSV

  B. JSON

  C. Parquet

  D. XML

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

• Question 1005:

  What is a best practice after creating a custom role?

  A. Create the custom role using the SYSADMIN role.

  B. Assign the custom role to the SYSADMIN role

  C. Assign the custom role to the PUBLIC role

  D. Add__CUSTOM to all custom role names

  Correct Answer: B

  When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top- most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

• Question 1006:

  Which stage type can not be altered and dropped?

  A. Database stage

  B. External stage

  C. Table stage

  D. User stage

  Correct Answer: B

• Question 1007:

  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

  Correct Answer: CD

• Question 1008:

  What is the purpose of an External Function?

  A. To call code that executes outside of Snowflake

  B. To run a function in another Snowflake database

  C. To share data in Snowflake with external parties

  D. To ingest data from on-premises data sources

  Correct Answer: A

  https://docs.snowflake.com/en/sql-reference/external-functions.html

• Question 1009:

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

  A. Columns can be aggregated

  B. Columns can be joined with an existing table

  C. Columns can be reordered

  D. Columns can be omitted

  E. Data can be loaded without the need to spin up a virtual warehouse

  Correct Answer: CD

• Question 1010:

  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

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/functions/pipe_usage_history.html