Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1401:

  Which Snowflake feature improves the performance of point lookup queries?

  A. Materialized views
  B. Automatic clustering
  C. Query acceleration service
  D. Search optimization service
  D. Search optimization service

  ---

  Explanation

• Question 1402:

  How is unstructured data retrieved from data storage?

  A. SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
  B. SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
  C. SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client. the unstructured data will be output to the client as files.
  D. SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.
  B. SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

  ---

  Explanation

• Question 1403:

  Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

  A. Area chart
  B. Box plot
  C. Heat grid
  D. Pie chart
  D. Pie chart

  ---

  Explanation

• Question 1404:

  What is the abbreviated form to get all the files in the stage for the current user?

  A. LIST @~;
  B. LS @~;
  C. LS @usr;
  D. SHOW @%;
  B. LS @~;

  ---

  Explanation

• Question 1405:

  How does the Snowflake search optimization service improve query performance?

  A. It improves the performance of range searches.
  B. It defines different clustering keys on the same source table.
  C. It improves the performance of all queries running against a given table.
  D. It improves the performance of equality searches.
  D. It improves the performance of equality searches.

  ---

  Explanation

• Question 1406:

  Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

  A. USAGE_VIEWER
  B. GOVERNANCE_VIEWER
  C. OBJECT_VIEWER
  D. SECURITY_VIEWER
  B. GOVERNANCE_VIEWER

  ---

  Explanation

• Question 1407:

  How long is a query visible in the Query History page in the Snowflake Web Interface (UI)?

  A. 60 minutes
  B. 24 hours
  C. 14 days
  D. 30 days
  C. 14 days

  ---

  Explanation

• Question 1408:

  What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  A. Authentication
  B. Resource management
  C. Virtual warehouse caching
  D. Query parsing and optimization
  E. Query execution
  F. Physical storage of micro-partitions
  A. Authentication
  B. Resource management
  D. Query parsing and optimization

  ---

  Explanation

• Question 1409:

  What is a directory table in Snowflake?

  A. A separate database object that is used to store file-level metadata.
  B. An object layered on a stage that is used to store file-level metadata.
  C. A database object with grantable privileges for unstructured data tasks.
  D. A Snowflake table specifically designed for storing unstructured files.
  B. An object layered on a stage that is used to store file-level metadata.

  ---

  Explanation

• Question 1410:

  If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

  A. The columns that are queried in the select clause.
  B. The columns with very high cardinality.
  C. The columns with many different values.
  D. The columns most actively used in the select filters.
  D. The columns most actively used in the select filters.

  ---

  Explanation