Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1:

  The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  A. Users

  B. Tables

  C. Databases

  D. Internal Stages

  Correct Answer: BCD

• Question 2:

  Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake?

  A. BUILD_SCOPED_FILE_URL

  B. GET_PRESIGNED_URL

  C. BUILD_STAGE_FILE_URL

  D. GET_STAGE_LOCATION

  Correct Answer: B

  The GET_PRESIGNED_URL function in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the

  file.

  To generate a pre-signed URL:

  SELECT GET_PRESIGNED_URL(@my_stage/file.txt);

  Once generated, the URL can be shared with external users or applications, enabling them to access the file directly.

  References:

  Snowflake Documentation: GET_PRESIGNED_URL

  Snowflake Documentation: Working with Stages

• Question 3:

  What are characteristics of Snowsight worksheets? (Choose two.)

  A. Worksheets can be grouped under folders, and a folder of folders.

  B. Each worksheet is a unique Snowflake session.

  C. Users are limited to running only one query on a worksheet.

  D. The Snowflake session ends when a user switches worksheets.

  E. Users can import worksheets and share them with other users.

  Correct Answer: BE

• Question 4:

  What are reasons for using the VALIDATE function in Snowflake after a COPY INTO command execution? (Choose two.)

  A. To validate the files that have been loaded earlier using the COPY INTO command

  B. To fix errors that were made during the execution of the COPY INTO command

  C. To return errors encountered during the execution of the COPY INTO command

  D. To identify potential issues in the COPY INTO command before it is executed

  E. To count the number of errors encountered during the execution of the COPY INTO command

  Correct Answer: AC

• Question 5:

  Which command should be used to generate a single file when unloading data from a Snowflake table into a file?

  A. PARTITION BY

  B. MAX_FILE_SIZE = 0

  C. SINGLE = TRUE

  D. OVERWRITE = TRUE

  Correct Answer: C

• Question 6:

  Which function can be used to convert semi-structured data into rows and columns?

  A. TABLE

  B. FLATTEN

  C. PARSE_JSON

  D. JSON_EXTRACT_PATH_TEXT

  Correct Answer: B

  FLATTEN can be used to convert semi-structured data to a relational representation.

• Question 7:

  Which table type has a Fail-safe period of 7 days?

  A. Temporary table

  B. Transient table

  C. Permanent table

  D. External table

  Correct Answer: C

• Question 8:

  What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)

  A. DISABLE_MFA

  B. MINS_TO_BYPASS_MFA

  C. PASSWORD

  D. MINS_TO_UNLOCK

  E. MUST_CHANGE_PASSWORD

  Correct Answer: AB

• Question 9:

  Which system function can be used to manage access to the data in a share and display certain data only to paying customers?

  A. SYSTEM$ALLOWLIST

  B. SYSTEM$ALLOWLIST_PRIVATELINK

  C. SYSTEM$AUTHORIZE_PRIVATELINK

  D. SYSTEM$IS_LISTING_PURCHASED

  Correct Answer: D

  https://other-docs.snowflake.com/en/collaboration/provider-listings-preparing

• Question 10:

  Which query will return a sample of a table with 1000 rows named testtable, in which each row has a 10% probability of being included in the sample?

  A. select * from testtable sample (0.1);

  B. select * from testtable sample (10);

  C. select * from testtable sample (0.1 rows);

  D. select * from testtable sample (10 rows);

  Correct Answer: B