Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1501:

  What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)

  A. Performing aggregate calculations
  B. Reordering the columns
  C. Grouping by operations
  D. Converting the datatypes
  E. Selecting the first few rows
  B. Reordering the columns
  D. Converting the datatypes

  ---

  Explanation

• Question 1502:

  Fail-safe is unavailable on which table types?

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

  ---

  Explanation

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

• Question 1503:

  Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

  A. Pipe
  B. External stage
  C. Task
  D. Stream
  A. Pipe

  ---

  Explanation

  Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 1504:

  When will Snowflake charge credits for the use of the Cloud Services layer?

  A. Credits will be charged whenever the Cloud Services layer is used.
  B. Credits will be charged only when running a Snowflake-provisioned compute warehouse COMPUTER_WH.
  C. Credits will be charged when the daily consumption of cloud services resources exceeds 10% of the daily warehouse usage.
  D. Credits will be charged only when a virtual warehouse consumes serverless compute services.
  A. Credits will be charged whenever the Cloud Services layer is used.

  ---

  Explanation

  Snowflake's Cloud Services layer manages metadata, authentication, and query optimization.

  Whenever these services are utilized (e.g., query parsing, metadata queries), credits are consumed, irrespective of virtual warehouse usage.

  Why Other Options Are Incorrect:

  B. Snowflake-provisioned warehouse: Cloud Services charges are independent of specific warehouse configurations.

  C. 10% of daily warehouse usage: No such threshold exists.

  D. Serverless compute: Cloud Services credits are charged irrespective of serverless compute.

  References:

  Cloud Services Layer

• Question 1505:

  Which function produces a lateral view of a VARIANT column?

  A. GET_PATH
  B. FLATTEN
  C. GET
  D. PARSE_JSON
  B. FLATTEN

  ---

  Explanation

• Question 1506:

  What does Snowflake recommend when planning virtual warehouse usage for a data load?

  A. Load the fewest possible number of large files.
  B. Dedicate a separate warehouse for loading data.
  C. Increase the size of the warehouse used.
  D. Use several single-cluster warehouses.
  B. Dedicate a separate warehouse for loading data.

  ---

  Explanation

• Question 1507:

  The Snowflake Search Optimization Services supports improved performance of which kind of query?

  A. Queries against large tables where frequent DML occurs
  B. Queries against tables larger than 1 TB
  C. Selective point lookup queries
  D. Queries against a subset of columns in a table
  C. Selective point lookup queries

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve% 20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY% 20columns)

• Question 1508:

  Which view will show the MOST recent information about table-level storage utilization?

  A. The TABLE_STORAGE_METRICS view in a Snowflake data share
  B. The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
  C. The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA
  D. The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA
  B. The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema

  ---

  Explanation

• Question 1509:

  Snowflake charges additional fees to Data providers for each share they create.

  A. True
  B. False
  B. False

  ---

  Explanation

  "The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

• Question 1510:

  What is the following SQL command used for?

  Select * from table(validate(t1, job_id => '_last'));

  A. To validate external table files in table t1 across all sessions
  B. To validate task SQL statements against table t1 in the last 14 days
  C. To validate a file for errors before it gets executed using a COPY command
  D. To return errors from the last executed COPY command into table t1 in the current session
  D. To return errors from the last executed COPY command into table t1 in the current session

  ---

  Explanation