Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1301:

  What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)

  A. OAuth
  B. Key pair authentication
  C. Federated authentication
  D. Multi-Factor Authentication (MFA)
  E. Username and password authentication
  A. OAuth
  E. Username and password authentication

  ---

  Explanation

• Question 1302:

  It is possible to load data into Snowflake without creating a named File Format object.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

• Question 1303:

  A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY. What should they do?

  A. Use the SECURITYADMIN role.
  B. Use the SYSADMIN role.
  C. Use the USERADMIN role.
  D. Contact Snowflake Support.
  D. Contact Snowflake Support.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/network-policies

• Question 1304:

  Which query metric can be used to monitor the health of a large table?

  A. Clustering depth
  B. Clustering key
  C. Total partition count
  D. Total number of rows
  A. Clustering depth

  ---

  Explanation

• Question 1305:

  Which minimum Snowflake edition allows for a dedicated metadata store?

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

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 1306:

  When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string `null' using which file format option?

  A. SKIP_BYTE_ORDER_MARK
  B. EMPTY_FIELD_AS_NULL
  C. NULL_IF
  D. ESCAPE_UNENCLOSED_FIELD
  C. NULL_IF

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-unload-considerations#empty-strings-and-null-values

• Question 1307:

  Which activities are managed by Snowflake's Cloud Services layer? (Choose two.)

  A. Authentication
  B. Access delegation
  C. Data pruning
  D. Data compression
  E. Query parsing and optimization
  A. Authentication
  E. Query parsing and optimization

  ---

  Explanation

• Question 1308:

  A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1;?

  A. The temporary table will take precedence over the permanent table.
  B. The permanent table will take precedence over the temporary table.
  C. An error will say there cannot be two tables with the same name in a schema.
  D. The table that was created most recently will take precedence over the older table.
  A. The temporary table will take precedence over the permanent table.

  ---

  Explanation

  All queries and other operations performed in the session on the table affect only the temporary table https://docs.snowflake.com/en/user-guide/tables-temp-transient#potential-naming-conflicts-with-other-table-types

• Question 1309:

  Which strategy is recommended to improve the performance of a large, complex query?

  A. Add more storage
  B. Convert to a multi-cluster warehouse
  C. Increase the size of the warehouse
  D. Run the query during off-peak hours
  C. Increase the size of the warehouse

  ---

  Explanation

  To improve the performance of compute-intensive queries, increasing the warehouse size (e.g., from Medium to Large or X-Large) provides more compute resources (CPU/memory) , allowing Snowflake to process queries faster. This is the

  most direct and effective method for performance optimization.

  Snowflake Docs: Warehouse Sizing "Larger warehouses provide more compute resources for faster performance."

• Question 1310:

  Which Snowflake data governance feature supports the tracking of sensitive data for compliance, discovery, protection, and resource usage?

  A. Row access policies
  B. Data classi cation
  C. Object dependencies
  D. Object tagging
  D. Object tagging

  ---

  Explanation