Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 381:

  Which types of URLs are provided by Snowflake to access unstructured data files? (Choose two).

  A. Absolute URL

  B. Dynamic URL

  C. File URL

  D. Relative URL

  E. Scoped URL

  Correct Answer: CE

  https://hevodata.com/learn/snowflake-unstructured-data/

• Question 382:

  What can be done to reduce queueing on a virtual warehouse?

  A. Increase the AUTO_SUSPEND setting for the warehouse.

  B. Change the warehouse to a multi-cluster warehouse.

  C. Increase the warehouse size.

  D. Lower the MAX_CONCURRENCY_LEVEL setting for the warehouse.

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/performance-query-warehouse-queue

• Question 383:

  Snowflake best practice recommends that which role be used to enforce a network policy on a Snowflake account?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. USERADMIN

  Correct Answer: B

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

• Question 384:

  What is the default behavior of internal stages in Snowflake?

  A. Named internal stages are created by default.

  B. Users must manually create their own internal stages.

  C. Data files are automatically staged to a default location.

  D. Each user and table are automatically allocated an internal stage.

  Correct Answer: D

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

• Question 385:

  The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?

  A. Medium

  B. Large

  C. 2X-Large

  D. 4X-Large

  Correct Answer: C

• Question 386:

  What storage cost is completely eliminated when a Snowflake table is defined as transient?

  A. Active

  B. Fail-safe

  C. Staged

  D. Time Travel

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/tables-temp-transient

• Question 387:

  How can a Snowflake user traverse semi-structured data?

  A. Insert a colon (:) between the VARIANT column name and any first-level element.

  B. Insert a colon (:) between the VARIANT column name and any second-level element.

  C. Insert a double colon (::) between the VARIANT column name and any first-level element.

  D. Insert a double colon (::) between the VARIANT column name and any second-level element.

  Correct Answer: A

• Question 388:

  Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. USERADMIN

  Correct Answer: C

  https://community.snowflake.com/s/article/Quickly-Visualize-Snowflake-s-Roles-Grants-and-Privileges

• Question 389:

  By default, which role allows a user to manage a Snowflake Data Exchange share?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. USERADMIN

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-access-privileges-shares

• Question 390:

  How does the PARTITION BY option affect an expression for a COPY INTO command?

  A. The unload operation partitions table rows into separate files unloaded to the specified table.

  B. The unload operation partitions table rows into separate files unloaded to the specified stage.

  C. A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.

  D. A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.

  Correct Answer: B

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