Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 861:

  What can a Snowflake user do in the Activity section in Snowsight?

  A. Create dashboards.
  B. Write and run SQL queries.
  C. Explore databases and objects.
  D. Explore executed query performance.
  D. Explore executed query performance.

  ---

  Explanation

• Question 862:

  What information is included in the display in the Query Profile? (Choose two.)

  A. Index hints used in query
  B. Credit usage details
  C. Clustering keys details
  D. Details and statistics for the overall query
  E. Graphical representation of the query processing plan
  D. Details and statistics for the overall query
  E. Graphical representation of the query processing plan

  ---

  Explanation

• Question 863:

  Which Snowflake objects consume storage? (Select TWO)

  A. Views
  B. Materialized views
  C. Temporary schemas
  D. Permanent tables
  E. External tables
  B. Materialized views
  D. Permanent tables

  ---

  Explanation

• Question 864:

  A user wants to access files stored in a stage without authenticating into Snowflake.

  Which type of URL should be used?

  A. File URL
  B. Staged URL
  C. Scoped URL
  D. Pre-signed URL
  D. Pre-signed URL

  ---

  Explanation

• Question 865:

  What can be used to process unstructured data?

  A. External tables
  B. The COPY INTO
  C. External functions
  D. Snowpipe
  A. External tables

  ---

  Explanation

• Question 866:

  A user executes the following SQL query:

  create table SALES_BKP like SALES;

  What are the cost implications for processing this query?

  A. Processing costs will be generated based on how long the query takes.
  B. Storage costs will be generated based on the size of the data.
  C. No costs will be incurred as the query will use metadata.
  D. The cost for running the virtual warehouse will be charged by the second.
  C. No costs will be incurred as the query will use metadata.

  ---

  Explanation

• Question 867:

  Which command is used to remove files from either external cloud storage or an internal stage?

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

  ---

  Explanation

• Question 868:

  By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ORGADMIN
  D. ORGADMIN

  ---

  Explanation

• Question 869:

  Which feature or service should be used to identify data about a department that was responsible for a recent revenue shortfall?

  A. Snowpark
  B. Snowpipe
  C. ML Functions
  D. Document AI
  A. Snowpark

  ---

  Explanation

• Question 870:

  What can be done to reduce queueing on a virtual warehouse?

  A. Increase the AUTO_SUSPEND setting for the warehouse.
  B. Change the warehouse to a multi-cluster warehouse.
  C. Increase the warehouse size.
  D. Lower the MAX_CONCURRENCY_LEVEL setting for the warehouse.
  B. Change the warehouse to a multi-cluster warehouse.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/performance-query-warehouse-queue