Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 191:

  Which Snowflake feature is used for both querying and restoring data?

  A. Cluster keys
  B. Time Travel
  C. Fail-safe
  D. Cloning
  B. Time Travel

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through% 20Snowflake%20Time%20Travel.

• Question 192:

  Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

  A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
  B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
  C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
  D. A user cannot specify a default warehouse when using the ODBC driver.
  E. The default virtual warehouse size can be changed at any time.
  C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
  E. The default virtual warehouse size can be changed at any time.

  ---

  Explanation

• Question 193:

  Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)

  A. When window functions are used incorrectly
  B. When there are exploding joins
  C. When there is a UNION without ALL
  D. When the SELECT DISTINCT command returns too many values
  E. When there are Common Table Expressions (CTEs) without a final SELECT statement
  B. When there are exploding joins
  C. When there is a UNION without ALL

  ---

  Explanation

• Question 194:

  Which role can create and manage Snowflake accounts?

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

  ---

  Explanation

• Question 195:

  Which command is used to download a data file from an internal stage into a local directory?

  A. PUT
  B. GET
  C. COPY_FILES
  D. COPY INTO
  B. GET

  ---

  Explanation

• Question 196:

  What is the maximum Time Travel retention period for a temporary Snowflake table?

  A. 90 days
  B. 1 day
  C. 7 days
  D. 45 days
  B. 1 day

  ---

  Explanation

• Question 197:

  What actions does the use of the PUT command do automatically? (Choose two.)

  A. It creates a file format object.
  B. It uses the last stage created.
  C. It compresses all files using GZIP.
  D. It encrypts the file data in transit.
  E. It creates an empty target table.
  C. It compresses all files using GZIP.
  D. It encrypts the file data in transit.

  ---

  Explanation

• Question 198:

  From what stage can a Snowflake user omit the FROM clause while loading data into a table?

  A. The user stage
  B. The table stage
  C. The internal named stage
  D. The external named stage
  B. The table stage

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy

• Question 199:

  What is the minimum Snowflake edition required to use Dynamic Data Masking?

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

  ---

  Explanation

• Question 200:

  When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

  A. SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
  B. SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
  C. SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
  D. SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);
  C. SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

  ---

  Explanation

  In Snowflake, SAMPLE (5 ROWS) ensures an exact count of 5 rows is returned from MY_TABLE, regardless of table size. This is different from SAMPLE SYSTEM or SAMPLE BERNOULLI, which use percentage-based sampling, potentially returning varying row counts based on probabilistic methods. The ROWS option is deterministic and does not depend on percentage, making it ideal when an exact row count is required.