Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 81:

  Which Snowflake objects can execute both DDL and DML statements?

  A. External functions
  B. Stored procedures
  C. User-De ned Functions (UDFs)
  D. User-De ned Table Functions (UDTFs)
  B. Stored procedures

  ---

  Explanation

• Question 82:

  A Snowflake user wants to share unstructured data through the use of secure views. Which URL types can be used? (Choose two.)

  A. Scoped URL
  B. HTTPS URL
  C. Cloud storage URL
  D. File URL
  E. Pre-signed URL
  A. Scoped URL
  E. Pre-signed URL

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/unstructured-data-sharing

• Question 83:

  By default, which Snowflake role is required to create a share?

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

  ---

  Explanation

• Question 84:

  What is used to extract the content of PDF files stored in Snowflake stages?

  A. FLATTEN function
  B. Window function
  C. HyperLogLog (HLL) function
  D. Java User-Defined Function (UDF)
  D. Java User-Defined Function (UDF)

  ---

  Explanation

• Question 85:

  A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).

  A. Database
  B. Standard tables
  C. External tables
  D. Standard views
  E. Schemas
  F. Pipes
  B. Standard tables
  C. External tables

  ---

  Explanation

• Question 86:

  Who can create network policies within Snowflake? (Select TWO).

  A. SYSADMIN only
  B. ORCADMIN only
  C. SECURITYADMIN or higher roles
  D. A role with the CREATE NETWORK POLICY privilege
  E. A role with the CREATE SECURITY INTEGRATION privilege
  C. SECURITYADMIN or higher roles
  D. A role with the CREATE NETWORK POLICY privilege

  ---

  Explanation

• Question 87:

  Which table is designed to store a catalog of stage files in cloud storage?

  A. Dynamic table
  B. Hybrid table
  C. Directory table
  D. Iceberg table
  C. Directory table

  ---

  Explanation

• Question 88:

  Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

  A. APPROXIMATE_SIMILARITY
  B. JAROWINKLER_SIMILARITY
  C. APPROXIMATE_JACCARD_INDEX
  D. MINHASH_COMBINE
  B. JAROWINKLER_SIMILARITY

  ---

  Explanation

• Question 89:

  Which user preferences can be set for a user profile in Snowsight? (Choose two.)

  A. Multi-Factor Authentication (MFA)
  B. Default database
  C. Default schema
  D. Notifications
  E. Username
  A. Multi-Factor Authentication (MFA)
  D. Notifications

  ---

  Explanation

  Setting User Details and Preferences: ------------------------------------------------------------------------------------- Profile photo Username (cannot be changed) First name Last name Password Email Default experience (Snowsight or Classic) Language (English, Japanese) *Notifications (Browser Notification) *Multi-factor authentication Session Timeout https://docs.snowflake.com/en/user-guide/ui-snowsight-gs#setting-user-details-and-preferences

• Question 90:

  The fail-safe retention period is how many days?

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

  ---

  Explanation

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