Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 391:

  What happens to the privileges granted to Snowflake system-defined roles?

  A. The privileges cannot be revoked.

  B. The privileges can be revoked by an ACCOUNTADMIN.

  C. The privileges can be revoked by an ORGADMIN.

  D. The privileges can be revoked by any user-defined role with appropriate privileges.

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-access-control-overview

• Question 392:

  Which Snowflake features can be enabled by calling the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function by a user with the ORGADMIN role? (Choose two.)

  A. Clustering

  B. Client redirect

  C. Fail-safe

  D. Search optimization service

  E. Account and database replication

  Correct Answer: BE

  https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter

• Question 393:

  What are characteristics of directory tables when used with unstructured data? (Choose two.)

  A. Only cloud storage stages support directory tables.

  B. Each directory table has grantable privileges of its own.

  C. Directory tables store a catalog of staged files in cloud storage.

  D. A directory table can be added explicitly to a stage when the stage is created.

  E. A directory table is a separate database object that can be layered explicitly on a stage.

  Correct Answer: CD

  Directory table: 1- its implicit not separate database object 2 - like external table stores file-level metadata about the data files in the stage 3 - has NO grantable privileges of its own

  https://docs.snowflake.com/en/user-guide/data-load-dirtables#what-is-a-directory-table

• Question 394:

  Which features are included in Snowsight? (Choose two.)

  A. Worksheet sharing

  B. Referencing SnowSQL

  C. Exploring the Snowflake Marketplace

  D. Changing the Snowflake account cloud provider

  E. Downloading query result data larger than 100 MB

  Correct Answer: AC

  https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour

• Question 395:

  How long can a data consumer who has a pre-signed URL access data files using Snowflake?

  A. Indefinitely

  B. Until the result_cache expires

  C. Until the retention_time is met

  D. Until the expiration_time is exceeded

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/functions/get_presigned_url

• Question 396:

  What mechanisms can be used to inform Snowpipe that there are staged files available to load into a Snowflake table? (Choose two.)

  A. Cloud messaging

  B. Email integrations

  C. Error notifications

  D. REST endpoints

  E. Snowsight interactions

  Correct Answer: AD

• Question 397:

  A Snowflake user needs to import a JSON file larger than 16 MB. What file format option could be used?

  A. trim_space = true

  B. compression = auto

  C. strip_outer_array = true

  D. strip_outer_array = false

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare

• Question 398:

  What is a feature of column-level security in Snowflake?

  A. Role access policies

  B. Network policies

  C. Internal tokenization

  D. External tokenization

  Correct Answer: D

  https://docs.snowflake.com/user-guide/security-column-intro

• Question 399:

  Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)

  A. When window functions are used incorrectly

  B. When there are exploding joins

  C. When there is a UNION without ALL

  D. When the SELECT DISTINCT command returns too many values

  E. When there are Common Table Expressions (CTEs) without a final SELECT statement

  Correct Answer: BC

• Question 400:

  What is the Fail-safe retention period for transient and temporary tables?

  A. 0 days

  B. 1 day

  C. 7 days

  D. 90 days

  Correct Answer: A

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