Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 441:

  How can a transient table be converted to a permanent table?

  A. Use the ALTER TABLE ... RENAME command.
  B. Use the CREATE TABLE AS SELECT (CTAS) command.
  C. Use the ALTER TABLE ... SWAP WITH command.
  D. Use the CREATE TABLE ... CLONE command.
  B. Use the CREATE TABLE AS SELECT (CTAS) command.

  ---

  Explanation

• Question 442:

  In Snowpipe, what is the default behavior of the ON_ERROR COPY option?

  A. CONTINUE
  B. SKIP_FILE
  C. SKIP_FILE
  D. ABORT_STATEMENT
  D. ABORT_STATEMENT

  ---

  Explanation

• Question 443:

  What is the EXPLAIN function used for in Snowflake?

  A. To compile a SQL statement and provide an execution plan using a virtual warehouse.
  B. To compile a SQL statement and provide an execution plan while consuming cloud service credits.
  C. To execute a SQL statement, and provide a history of the query execution and the number of compute credits consumed.
  D. To execute a SQL statement and provide a history of the query execution including the number of cloud services credits consumed.
  A. To compile a SQL statement and provide an execution plan using a virtual warehouse.

  ---

  Explanation

• Question 444:

  Which statement will trigger a stream to advance its offset?

  A. DESCRIBE STREAM
  B. ALTER STREAM
  C. DROP STREAM
  D. CREATE OR REPLACE STREAM
  D. CREATE OR REPLACE STREAM

  ---

  Explanation

  A stream in Snowflake tracks changes (e.g., inserts, updates, and deletes) to a table. Its offset advances only when the stream is consumed or re-created. CREATE OR REPLACE STREAM triggers the stream to reset its offset, effectively advancing it by overwriting the existing stream definition. Other operations like querying the stream (SELECT) or applying changes (INSERT) would also advance offsets, but only CREATE OR REPLACE affects the offset in this context. Why Other Options Are Incorrect:

  A. DESCRIBE STREAM: Does not affect the stream offset; it only retrieves metadata.

  B. ALTER STREAM: Modifies the stream properties but does not advance the offset.

  C. DROP STREAM: Deletes the stream but does not advance its offset.

  References:

  Snowflake Streams Documentation

• Question 445:

  Use of which feature or setting consumes Snowflake credits, but generates no storage costs?

  A. Materialized view
  B. Table clustering
  C. Query acceleration service
  D. Search optimization service
  D. Search optimization service

  ---

  Explanation

• Question 446:

  Which of the following SQL statements will list the version of the drivers currently being used?

  A. Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
  B. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
  C. Execute SELECT CURRENT_CLIENT(); from an application
  D. Execute SELECT CURRENT_VERSION(); from the Python Connector
  C. Execute SELECT CURRENT_CLIENT(); from an application

  ---

  Explanation

• Question 447:

  What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)

  A. A VARIANT column
  B. A column with very low cardinality
  C. A column with very high cardinality
  D. A column that is most actively used in selective filters
  E. A column that is most actively used in join predicates
  D. A column that is most actively used in selective filters
  E. A column that is most actively used in join predicates

  ---

  Explanation

• Question 448:

  At which point is data encrypted when using a PUT command?

  A. When it reaches the virtual warehouse
  B. When it gets micro-partitioned
  C. Before it is sent from the user's machine
  D. After it reaches the internal stage
  C. Before it is sent from the user's machine

  ---

  Explanation

• Question 449:

  Which role has the ability to create a share from a shared database by default?

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

  ---

  Explanation

• Question 450:

  What are the least privileges needed to view and modify resource monitors? (Choose two.)

  A. SELECT
  B. OWNERSHIP
  C. MONITOR
  D. MODIFY
  E. USAGE
  C. MONITOR
  D. MODIFY

  ---

  Explanation