Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 151:

  A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

  How can this worksheet be shared?

  A. Create a zero-copy clone of the worksheet and grant permissions to teammates
  B. Create a private Data Exchange so that any teammate can use the worksheet
  C. Share the worksheet with teammates within Snowsight
  D. Create a database and grant all permissions to teammates
  C. Share the worksheet with teammates within Snowsight

  ---

  Explanation

• Question 152:

  How can files in a stage be loaded after the le metadata has expired? (Choose two.)

  A. Set the LOAD_UNCERTAIN_FILES option to TRUE.
  B. Remove the files from the stage and reload them.
  C. Set the FORCE parameter to TRUE.
  D. Truncate the target table and reload the les.
  E. Use the ALTER TABLE...REFRESH command
  A. Set the LOAD_UNCERTAIN_FILES option to TRUE.
  C. Set the FORCE parameter to TRUE.

  ---

  Explanation

• Question 153:

  Which Snowflake object is supported by both database replication and replication groups?

  A. Pipes
  B. Users
  C. Stages
  D. Materialized views
  A. Pipes

  ---

  Explanation

• Question 154:

  Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

  A. Free listing
  B. Paid listing
  C. Direct share
  D. Data Exchange
  D. Data Exchange

  ---

  Explanation

• Question 155:

  Which Snowflake partner specializes in data catalog solutions?

  A. Alation
  B. DataRobot
  C. dbt
  D. Tableau
  A. Alation

  ---

  Explanation

  Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, and Govern Data Across an Enterprise.

  https://docs.snowflake.com/en/user-guide/ecosystem-all.html

• Question 156:

  What are the key characteristics of ACOUNT_USAGE views? (Choose two.)

  A. There is no data latency.
  B. The data latency can vary from 45 minutes to 3 hours.
  C. The historical data is not retained.
  D. The historical data can be retained from 7 days to 6 months.
  E. Records for dropped objects are included in each view.
  B. The data latency can vary from 45 minutes to 3 hours.
  E. Records for dropped objects are included in each view.

  ---

  Explanation

• Question 157:

  Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows into a file in JSON format? (Choose two.)

  A. PUT
  B. GET
  C. COPY
  D. EXPORT
  E. OBJECT_CONSTRUCT
  C. COPY
  E. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 158:

  Which type of query would benefit from enabling the query acceleration service on the virtual warehouse?

  A. Queries with no lters or aggregation
  B. Queries that are queued in the warehouse
  C. Queries that use more resources than the typical query
  D. Queries that contain a high cardinality GROUP BY expression
  D. Queries that contain a high cardinality GROUP BY expression

  ---

  Explanation

• Question 159:

  How does Snowflake optimize queries on tables by leveraging the sorting and storage of data within micro-partitions?

  A. The data is pruned by column to eliminate unnecessary micro-partitions, then the rows within the remaining micro-partitions are ltered.
  B. The data is pruned by micro-partitions based on column values, then rows within the remaining micro-partitions are ltered.
  C. Any micro-partitions that are not needed for the query are pruned, then the data within the remaining micro-partitions is pruned by column.
  D. The data within micro-partitions is sorted by rows, then the columns are ltered based on the query conditions.
  B. The data is pruned by micro-partitions based on column values, then rows within the remaining micro-partitions are ltered.

  ---

  Explanation

• Question 160:

  What is the MINIMUM Snowflake edition required to use the column-level security feature?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  B. Enterprise

  ---

  Explanation