Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 641:

  Which of the following statements describe features of Snowflake data caching? (Choose two.)

  A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  B. When the data cache is full, the least-recently used data will be cleared to make room.
  C. A user can only access their own queries from the query result cache.
  D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  E. The RESULT_SCAN table function can access and filter the contents of the query result cache.
  B. When the data cache is full, the least-recently used data will be cleared to make room.
  E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

  ---

  Explanation

• Question 642:

  Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?

  A. ACCESS_HYSTORY
  B. LOGIN_HYSTORY
  C. SESSIONS
  D. QUERY_HISTORY
  B. LOGIN_HYSTORY

  ---

  Explanation

• Question 643:

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

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

  ---

  Explanation

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

• Question 644:

  When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

  A. Concurrency
  B. Performance
  B. Performance

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance

• Question 645:

  Which command can be used to load data files into a Snowflake stage?

  A. JOIN
  B. COPY INTO
  C. PUT
  D. GET
  C. PUT

  ---

  Explanation

• Question 646:

  Which of the following objects can be cloned? (Choose four.)

  A. Tables
  B. Named File Formats
  C. Schemas
  D. Shares
  E. Databases
  F. Users
  A. Tables
  B. Named File Formats
  C. Schemas
  E. Databases

  ---

  Explanation

  Which Objects Can Be Cloned?

  Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

• Question 647:

  What is the minimum Snowflake edition required to create a materialized view?

  A. Standard Edition
  B. Enterprise Edition
  C. Business Critical Edition
  D. Virtual Private Snowflake Edition
  B. Enterprise Edition

  ---

  Explanation

  Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require% 20Enterprise%20Edition,upgrading%2C %20please%20contact%20Snowflake%20Support.

• Question 648:

  Which statement MOST accurately describes clustering in Snowflake?

  A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
  C. The clustering key must be included in the COPY command when loading data into Snowflake.
  D. Clustering can be disabled within a Snowflake account.
  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

  ---

  Explanation

• Question 649:

  Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

  A. 1 Hour
  B. 3 Hours
  C. 12 hours
  D. 24 hours
  D. 24 hours

  ---

  Explanation

  https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

• Question 650:

  Which role in Snowflake allows a user to enable replication for multiple accounts?

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

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/database-replication-config