Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 111:

  By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

  A. 0 days
  B. 1 day
  C. 7 days
  D. 14 days
  B. 1 day

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-time-travel

• Question 112:

  Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  A. The validation_mode option is used when creating an Internal Stage
  B. validation_mode=return_all_errors is a parameter of the copy command
  C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
  B. validation_mode=return_all_errors is a parameter of the copy command
  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

• Question 113:

  According to best practices, which table type should be used if the data can be recreated outside of Snowflake?

  A. Permanent table
  B. Temporary table
  C. Transient table
  D. Volatile table
  C. Transient table

  ---

  Explanation

• Question 114:

  The ORDERS table contains 12,000 rows. Which query will return 10 rows that are randomly sampled from the table every time the query is run?

  A. select * from ORDERS fetch 10;
  B. select * from ORDERS limit 10;
  C. select * from ORDERS sample (10);
  D. select * from ORDERS tablesample (10 rows);
  D. select * from ORDERS tablesample (10 rows);

  ---

  Explanation

• Question 115:

  What type of query benefits the MOST from search optimization?

  A. A query that uses only disjunction (i.e., OR) predicates
  B. A query that includes analytical expressions
  C. A query that uses equality predicates or predicates that use IN
  D. A query that filters on semi-structured data types
  C. A query that uses equality predicates or predicates that use IN

  ---

  Explanation

  https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

• Question 116:

  What is the recommended way to obtain a cloned table with the same grants as the source table?

  A. Clone the table with the COPY GRANTS command.
  B. Use an ALTER TABLE command to copy the grants.
  C. Clone the schema then drop the unwanted tables.
  D. Create a script to extract grants and apply them to the cloned table.
  A. Clone the table with the COPY GRANTS command.

  ---

  Explanation

• Question 117:

  Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

  A. DATA_RETENTION_TIME_IN_DAYS
  B. MAX_DATA_EXTENSION_TIME_IN_DAYS
  C. MIN_DATA_RETENTION_TIME_IN_DAYS
  D. MAX_CONCURRENCY_LEVEL
  C. MIN_DATA_RETENTION_TIME_IN_DAYS

  ---

  Explanation

• Question 118:

  Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

  Which diagram indicates a well-clustered table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

  ---

  Explanation

• Question 119:

  When initially creating an account in Snowflake, which settings can be specified? (Choose two.)

  A. Account name
  B. Organization name
  C. Account locator
  D. Region
  E. Snowflake edition
  A. Account name
  E. Snowflake edition

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/sql/create-account

• Question 120:

  Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

  A. Directory
  B. File
  C. Pre-signed
  D. Scoped
  C. Pre-signed

  ---

  Explanation