Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 401:

  Which of the following commands cannot be used within a reader account?

  A. CREATE SHARE
  B. ALTER WAREHOUSE
  C. DROP ROLE
  D. SHOW SCHEMAS
  E. DESCRBE TABLE
  A. CREATE SHARE

  ---

  Explanation

• Question 402:

  What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

  A. 1
  B. 5
  C. 10
  D. 100
  C. 10

  ---

  Explanation

• Question 403:

  Which authentication method requires access to a secure le that is only stored on the user's local device?

  A. Password authentication
  B. Key-pair authentication
  C. Multi-Factor Authentication (MFA)
  D. Federated authentication
  B. Key-pair authentication

  ---

  Explanation

• Question 404:

  Which Snowflake object can be created to be temporary?

  A. Role
  B. Stage
  C. User
  D. Storage integration
  B. Stage

  ---

  Explanation

• Question 405:

  What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
  B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
  C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
  F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

  ---

  Explanation

• Question 406:

  If a JOIN operation is based on two columns which both contain NULL values, what SQL function will return results?

  A. An NVL function used to change the NULL values to another value
  B. An equal_null function
  C. A NULLIF function
  D. An I FNULL function used to change the NULL values to another value
  A. An NVL function used to change the NULL values to another value

  ---

  Explanation

  In SQL, NULL values are not equal to other NULL values. To make comparisons work in join operations, the NVL function can replace NULL with a non-NULL value.

  Example:

  SELECT *

  FROM table1 t1

  JOIN table2 t2

  ON NVL(t1.col, 'default') = NVL(t2.col, 'default'); Why Other Options Are Incorrect:

  B. Equal_null function: No such function exists in Snowflake SQL.

  C. NULLIF function: Used to return NULL when two values are equal, not for handling NULL in joins.

  D. IFNULL function: Similar to NVL but less commonly used in this context.

  References:

  NVL Function Documentation

• Question 407:

  Which strategy for optimizing virtual warehouse performance should be used to speed the execution of a very large query?

  A. Use the query acceleration service.
  B. Enable the search optimization service.
  C. Convert to a multi-cluster warehouse.
  D. Increase the size of the warehouse.
  A. Use the query acceleration service.

  ---

  Explanation

• Question 408:

  How does a Snowflake user enable Multi-Factor Authentication (MFA)?

  A. The user must enroll themselves through the web interface.
  B. The user must submit their encrypted private key to Snowflake.
  C. The user must sign up with Duo Mobile for approval to use the service.
  D. The user must configure Snowflake to use Single Sign-On (SSO).
  A. The user must enroll themselves through the web interface.

  ---

  Explanation

• Question 409:

  Which of the following statements would be used to export/unload data from Snowflake?

  A. COPY INTO @stage
  B. EXPORT TO @stage
  C. INSERT INTO @stage
  D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
  A. COPY INTO @stage

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

• Question 410:

  Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?

  A. Query Profile
  B. Query history
  C. Visualization chart
  D. Query acceleration service
  A. Query Profile

  ---

  Explanation

  The Query Profile tool in Snowflake provides detailed execution statistics for queries, including execution time, micro-partition scans, and caching information. It is available to users at no additional cost and is accessible via the Snowflake UI.

  References:

  Snowflake Documentation: Query Profile

  Query Optimization in Snowflake