Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 821:

  What is the default access of a securable object until other access is granted?

  A. No access
  B. Read access
  C. Write access
  D. Full access
  A. No access

  ---

  Explanation

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

• Question 822:

  How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

  A. Use the SHOW STAGES command.
  B. Use the DESCRIBE STAGE command.
  C. Use the GET_ABSOLUTE_PATH function.
  D. Use the GET_STAGE_LOCATION function.
  D. Use the GET_STAGE_LOCATION function.

  ---

  Explanation

• Question 823:

  What command will return a list of files that have been unloaded to a user stage?

  A. DESC @~
  B. GET @~
  C. SHOW @~
  D. LIST @~
  D. LIST @~

  ---

  Explanation

• Question 824:

  How a Snowpipe charges calculated?

  A. Per-second/per Warehouse size
  B. Per-second/per-core granularity
  C. Number of Pipes in account
  D. Total storage bucket size
  B. Per-second/per-core granularity

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

• Question 825:

  Which option will replace NULL values with an empty string while unloading data into a file?

  A. null_if=('NULL')
  B. null_if= ('')
  C. FIELD_OPTIONALLY_ENCLOSED_BY = NONE
  D. EMPTY_FIELD_AS_NULL = TRUE
  B. null_if= ('')

  ---

  Explanation

• Question 826:

  Which of the following objects is not covered by Time Travel?

  A. Tables
  B. Schemas
  C. Databases
  D. Stages
  D. Stages

  ---

  Explanation

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

• Question 827:

  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 828:

  The customer table in the Tl database is accidentally dropped. Which privileges are required to restore this table? (Select TWO).

  A. select privilege on the customer table
  B. ownership privilege on the customer table
  C. All privileges on the customer table
  D. All privileges on the TI database
  E. create table privilege on the Tl database
  B. ownership privilege on the customer table
  D. All privileges on the TI database

  ---

  Explanation

  To restore a dropped table in Snowflake, you need specific privileges: Why Other Options Are Incorrect:

  A. Select privilege: Only allows querying data, not restoration.

  C. All privileges on the table: The table no longer exists, so this does not apply.

  E. Create table privilege: This allows creating new tables, not restoring dropped ones.

  References:

  Undrop Table

  Snowflake Privileges Documentation

• Question 829:

  Which type of table corresponds to a single Snowflake session?

  A. Temporary
  B. Translent
  C. Provisional
  D. Permanent
  A. Temporary

  ---

  Explanation

  Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

  https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder% 20of%20the%20session.

• Question 830:

  What Snowflake feature or service is used to prevent third parties from reading data while it is at rest or in transit?

  A. Network policies
  B. Zero-copy cloning
  C. End-to-end encryption
  D. Incremental data snapshots
  C. End-to-end encryption

  ---

  Explanation