Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 461:

  There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.

  What is causing this to occur?

  A. The warehouse is queuing the queries, increasing the overall query execution time.
  B. The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.
  C. The application is not using the latest native ODBC driver which is causing latency.
  D. The queries are not taking advantage of the data cache.
  A. The warehouse is queuing the queries, increasing the overall query execution time.

  ---

  Explanation

• Question 462:

  Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Select TWO.)

  A. A column that appears most frequently in ORDER BY operations
  B. A column that appears most frequently in r.im z operations
  C. A column that appears most frequently in GROUP BY operations
  D. A column that appears most frequently in aggregate operations
  E. A column that appears most frequently in join operations
  A. A column that appears most frequently in ORDER BY operations
  B. A column that appears most frequently in r.im z operations

  ---

  Explanation

  Data Clustering Keys help Snowflake optimize performance by physically organizing data in micro-partitions based on specified columns. Columns frequently used in ORDER BY or WHERE clauses benefit the most because clustering

  improves pruning, reducing the number of micro-partitions scanned.

  Why Other Options Are Incorrect:

  C. GROUP BY: Aggregate operations benefit less from clustering.

  D. Aggregate operations: Clustering has limited effect here unless combined with filtering in WHERE.

  E. JOIN operations: Joins rely more on table structure than clustering.

  References:

  Clustering Keys Documentation

• Question 463:

  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.
  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.

  ---

  Explanation

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

  Which statement is true of zero-copy cloning?

  A. It increases storage costs as cloning a table requires storing its data twice
  B. A cloned table includes the load history of the original source
  C. It is licensed as an additional Snowflake feature
  D. All micro-partitions between the original and cloned tables are fully shared
  D. All micro-partitions between the original and cloned tables are fully shared

  ---

  Explanation

• Question 465:

  Why would a Snowflake user choose to use a transient table?

  A. To store data for long-term analysis
  B. To store large data files that are used frequently
  C. To create a permanent table for ongoing use in ELT
  D. To store transitory data that needs to be maintained beyond the session
  D. To store transitory data that needs to be maintained beyond the session

  ---

  Explanation

  transient tables are specifically designed for transitory data that needs to be maintained beyond each session https://docs.snowflake.com/en/user-guide/tables-temp-transient#transient-tables

• Question 466:

  User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history. What will happen if User2 tries to access the query history?

  A. If User2 has the SYSADMIN role they will be able to see the results.
  B. If User2 has the SECURITYADMIN role they will be able to see the results.
  C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
  D. User2 will be unable to view the result set of the query executed by User1.
  D. User2 will be unable to view the result set of the query executed by User1.

  ---

  Explanation

  You can view results only for queries you have executed. If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result.

  https://docs.snowflake.com/en/user-guide/ui-history

• Question 467:

  How does Snowflake handle the data retention period for a table if a stream has not been consumed?

  A. The data retention period s reduced to a minimum of 14 days.
  B. The data retention period is permanently extended for the table.
  C. The data retention period is temporarily extended to the stream's offset.
  D. The data retention period is not affected by the stream consumption.
  C. The data retention period is temporarily extended to the stream's offset.

  ---

  Explanation

• Question 468:

  When cloning a database, what is cloned with the database? (Choose two.)

  A. Privileges on the database
  B. Existing child objects within the database
  C. Future child objects within the database
  D. Privileges on the schemas within the database
  E. Only schemas and tables within the database
  B. Existing child objects within the database
  D. Privileges on the schemas within the database

  ---

  Explanation

• Question 469:

  Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  A. Number of users
  B. Warehouse size
  C. Amount of data processed
  D. # of clusters for the Warehouse
  B. Warehouse size
  D. # of clusters for the Warehouse

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage

  "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."

• Question 470:

  What consideration should be made when loading data into Snowflake?

  A. Create small data files and stage them in cloud storage frequently.
  B. Create large data files to maximize the processing overhead for each file.
  C. The number of load operations that run in parallel can exceed the number of data files to be loaded.
  D. The number of data files that are processed in parallel is determined by the virtual warehouse.
  D. The number of data files that are processed in parallel is determined by the virtual warehouse.

  ---

  Explanation