Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1571:

  What can be used to improve the performance of queries that are run on an external table?

  A. Search Optimization Service
  B. Query Acceleration Service
  C. Clustering key
  D. Materialized view
  D. Materialized view

  ---

  Explanation

  To optimize query performance on external tables, you can define a materialized view on top of the external table. Snowflake will manage and cache the result for faster retrieval.

  Snowflake Docs: External Tables with Materialized Views

• Question 1572:

  Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?

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

  ---

  Explanation

• Question 1573:

  What is the primary purpose of partitioning staged data files for regular data loads?

  A. To improve the performance of data loads
  B. To compress the data for efficient storage
  C. To encrypt the data for enhanced security
  D. To organize the data into subfolders for easy browsing
  A. To improve the performance of data loads

  ---

  Explanation

• Question 1574:

  If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

  A. 60
  B. 91
  C. 120
  D. 121
  C. 120

  ---

  Explanation

• Question 1575:

  Snowflake charges a premium for storing semi-structured data.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

• Question 1576:

  What are benefits of using Snowpark with Snowflake? (Choose two.)

  A. Snowpark uses a Spark engine to generate optimized SQL query plans.
  B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.
  C. Snowpark does not require that a separate cluster be running outside of Snowflake.
  D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
  E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).
  C. Snowpark does not require that a separate cluster be running outside of Snowflake.
  D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

  ---

  Explanation

• Question 1577:

  Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?

  A. BUILD_SCOPED_FILE_URL
  B. BUILD_STAGE_FILE_URL
  C. GET_ABSOLUTE_PATH
  D. GET_PRESIGNED_URL
  B. BUILD_STAGE_FILE_URL

  ---

  Explanation

• Question 1578:

  How are clusters handled when the Economy scaling policy is set on a multi-cluster virtual warehouse?

  A. A new cluster starts when the system detects that there is one or more queries queued waiting for an available cluster.
  B. A new cluster will start every 60 seconds if there are queued queries that have been waiting for more than 30 seconds for an available cluster.
  C. A new cluster starts only if the system estimates that the queued queries will require resources that will keep the new cluster busy for at least 6 minutes.
  D. A cluster will shut down after 3 system checks indicating that the cluster has been under-utilized for a minimum of 6 minutes.
  C. A new cluster starts only if the system estimates that the queued queries will require resources that will keep the new cluster busy for at least 6 minutes.

  ---

  Explanation

  Under the Economy scaling policy, Snowflake delays starting a new cluster until it's sure the queries will utilize it effectively for ~6 minutes . This reduces costs but may slightly delay query execution.

  Snowflake Docs: Economy Scaling Policy

• Question 1579:

  Which drivers or connectors are supported by Snowflake? (Select TWO)

  A. Perl Connector
  B. MongoDB Rust Driver
  C. Go Snowflake Driver
  D. Cobol Driver
  E. Snowflake Connector for Python
  C. Go Snowflake Driver
  E. Snowflake Connector for Python

  ---

  Explanation

  Snowflake supports a wide range of drivers and connectors to integrate with different programming languages and platforms. Two key supported options are:

  References:

  Snowflake Documentation: Supported Drivers and Connectors Snowflake Go Driver

  Snowflake Python Connector

• Question 1580:

  In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

  A. Compute Credits = 50 Credits Cloud Services = 10
  B. Compute Credits = 80 Credits Cloud Services = 5
  C. Compute Credits = 10 Credits Cloud Services = 9
  D. Compute Credits = 120 Credits Cloud Services = 10
  E. Compute Credits = 200 Credits Cloud Services = 26
  A. Compute Credits = 50 Credits Cloud Services = 10
  E. Compute Credits = 200 Credits Cloud Services = 26

  ---

  Explanation