Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1431:

  In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

  A. Bytes scanned
  B. Bytes sent over the network
  C. Number of partitions scanned
  D. Percentage scanned from cache
  E. External bytes scanned
  C. Number of partitions scanned
  D. Percentage scanned from cache

  ---

  Explanation

• Question 1432:

  What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

  A. 1 Kilobyte (KB)
  B. 1 Megabyte (MB)
  C. 1 Gigabyte (GB)
  D. 1 Terabyte (TB)
  D. 1 Terabyte (TB)

  ---

  Explanation

• Question 1433:

  When retrieving data from a table which type of query will benefit the MOST from use of the search optimization service?

  A. Queries with unpredictable data volumes.
  B. Queries with highly-selective table filters that return a small subset of rows.
  C. Queries on fields in a VARIANT column that will return all data as structured data.
  D. Queries that involve one or more columns inside the cluster key using the lowest cardinality to select filters.
  C. Queries on fields in a VARIANT column that will return all data as structured data.

  ---

  Explanation

• Question 1434:

  A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two)

  A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
  B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
  C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
  D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
  B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
  D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

  ---

  Explanation

  The results cache will only be used if it's the same query AND the same role executing the query

• Question 1435:

  Which command can be used to delete staged files from a Snowflake stage when the files are no longer needed?

  A. DELETE
  B. DROP
  C. REMOVE
  D. TRUNCATE TABLE
  C. REMOVE

  ---

  Explanation

• Question 1436:

  Which privilege is required for a user to be able to view a resource monitor?

  A. USAGE
  B. SELECT
  C. MONITOR
  D. OPERATE
  C. MONITOR

  ---

  Explanation

  The MONITOR privilege is required to view a resource monitor in Snowflake. It allows users to track and analyze resource usage (e.g., compute and storage) for virtual warehouses.

  Example:

  GRANT MONITOR ON ACCOUNT TO ROLE my_role;

  References:

  Snowflake Documentation: Resource Monitors

  Snowflake Privileges

• Question 1437:

  Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

  A. FORCE = TRUE
  B. FORCE = FALSE
  C. LOAD_UNCERTAIN_FILES = TRUE
  D. LOAD_UNCERTAIN_FILES = FALSE
  A. FORCE = TRUE

  ---

  Explanation

• Question 1438:

  What services are provided by the cloud services layer in Snowflake? (Choose two.)

  A. Metadata management
  B. Object authorization
  C. Authentication
  D. Query execution
  E. Result caching
  A. Metadata management
  C. Authentication

  ---

  Explanation

• Question 1439:

  What can be interpreted based on the number of nodes reported in a Query Profile?

  A. Query execution time
  B. Network bandwidth during query execution
  C. Data spillage
  D. Compute required for metadata management
  A. Query execution time

  ---

  Explanation

• Question 1440:

  What can a directory table be used for? (Select TWO)

  A. Retrieve a list of all unstructured files on a stage.
  B. Set an automatic refresh of the metadata for a directory table on internal and external stages.
  C. Remove files from a directory table using the GET command.
  D. Create a view for unstructured data.
  E. Process unstructured data using Snowflake system-defined functions.
  A. Retrieve a list of all unstructured files on a stage.
  B. Set an automatic refresh of the metadata for a directory table on internal and external stages.

  ---

  Explanation

  A directory table is a special Snowflake-managed table that stores metadata about unstructured data files (such as images, videos) in a stage.

  It supports automatic metadata refresh .

  It enables listing and querying file-level details .

  Snowflake Docs: Directory Tables