Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 271:

  What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

  A. Repair the failed resources.
  B. Restart failed resources.
  C. Queue the failed resources
  D. Provision the failed resources
  A. Repair the failed resources.

  ---

  Explanation

• Question 272:

  Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  A. PUT
  B. GET
  C. COPY
  D. SELECT
  B. GET

  ---

  Explanation

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

• Question 273:

  It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

  A. True
  B. False
  A. True

  ---

  Explanation

• Question 274:

  When an object is created in Snowflake, who owns the object?

  A. The public role
  B. The user's default role
  C. The current active primary role
  D. The owner of the parent schema
  C. The current active primary role

  ---

  Explanation

• Question 275:

  What do temporary and transient tables have in common in Snowflake? (Choose two.)

  A. Both tables have no Fail-safe period.
  B. Both tables have data retention period maximums of one day.
  C. Both tables are visible only to a single user session.
  D. For both tables, the retention period ends when the tables are dropped.
  E. For both tables, the retention period does not end when the session ends.
  A. Both tables have no Fail-safe period.
  B. Both tables have data retention period maximums of one day.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-temp-transient#comparison-of-table-types

• Question 276:

  What is the MINIMUM Snowflake edition required it a user needs to replicate both virtual warehouses and roles?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  C. Business Critical

  ---

  Explanation

  To replicate both virtual warehouses and roles, Snowflake requires at least the Business Critical edition.

  This edition supports advanced features like replication of compute resources and role configurations, enabling seamless cross-region and cross-account capabilities.

  References:

  Snowflake Documentation: Editions

  Snowflake Cross-Region Replication

• Question 277:

  What role is required to use Partner Connect?

  A. ACCOUNTADMIN
  B. ORGADMIN
  C. SECURITYADMIN
  D. SYSADMIN
  A. ACCOUNTADMIN

  ---

  Explanation

• Question 278:

  Floating point values are truncated when unloaded to which file format?

  A. ORC
  B. CSV
  C. Avro
  D. Parquet
  B. CSV

  ---

  Explanation

• Question 279:

  What actions can be performed by consumers of shared databases? (Choose two.)

  A. Create a clone of the database.
  B. Edit the comments for the database.
  C. Query Time Travel data on the database.
  D. Create streams on objects in the database.
  E. Query data from the objects in the database.
  D. Create streams on objects in the database.
  E. Query data from the objects in the database.

  ---

  Explanation

• Question 280:

  What will the SQL command DROP STAGE do for external stages in Snowflake?

  A. Remove a stage.
  B. Remove files from a stage.
  C. Retrieve a stage from Time Travel.
  D. Move a stage from one location to another.
  A. Remove a stage.

  ---

  Explanation