Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 101:

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

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPC)

  Correct Answer: D

• Question 102:

  A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

  A. Organize files into logical paths

  B. Store the files on the external stage to ensure caching is maintained

  C. Use pattern matching for regular expression execution

  D. Load the data in one large file

  Correct Answer: D

• Question 103:

  Network policies can be applied to which of the following Snowflake objects? (Choose two.)

  A. Roles

  B. Databases

  C. Warehouses

  D. Users

  E. Accounts

  Correct Answer: AD

• Question 104:

  Which statement describes pruning?

  A. The filtering or disregarding of micro-partitions that are not needed to return a query.

  B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

  C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

  D. The ability to allow the result of a query to be accessed as if it were a table.

  Correct Answer: A

• Question 105:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management

  B. Metadata management

  C. Query execution

  D. Query parsing and optimization

  E. Permanent storage of micro-partitions

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20required,rows%20from%20tables%20and%20views)

• Question 106:

  What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: B

• Question 107:

  How often are the Account and Table master keys automatically rotated by Snowflake?

  A. 30 Days

  B. 60 Days

  C. 90 Days

  D. 365 Days.

  Correct Answer: D

• Question 108:

  A running virtual warehouse is suspended.

  What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  A. 1 second

  B. 60 seconds

  C. 5 minutes

  D. 60 minutes

  Correct Answer: B

• Question 109:

  Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  A. STRIP_NULL_VALUES

  B. SKIP_BYTE_ORDER_MARK

  C. REPLACE_INVALID_CHARACTERS

  D. VALIDATION_MODE

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

• Question 110:

  Which Snowflake tool would be BEST to troubleshoot network connectivity?

  A. SnowCLI

  B. SnowUI

  C. SnowSQL

  D. SnowCD

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.