Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 151:

  Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

  A. Pre-signed URL

  B. Scoped URL

  C. Signed URL

  D. File URL

  Correct Answer: C

• Question 152:

  What are supported file formats for unloading data from Snowflake? (Choose three.)

  A. XML

  B. JSON

  C. Parquet

  D. ORC

  E. AVRO

  F. CSV

  Correct Answer: BCF

• Question 153:

  What type of query benefits the MOST from search optimization?

  A. A query that uses only disjunction (i.e., OR) predicates

  B. A query that includes analytical expressions

  C. A query that uses equality predicates or predicates that use IN

  D. A query that filters on semi-structured data types

  Correct Answer: C

  Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

• Question 154:

  What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

  A. The explain plan output is available graphically.

  B. An explain plan can be used to conduct performance analysis without executing a query.

  C. An explain plan will handle queries with temporary tables and the query profiler will not.

  D. An explain plan's output will display automatic data skew optimization information.

  Correct Answer: B

• Question 155:

  Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  A. Bytes sent over network

  B. Percentage scanned from cache

  C. Partitions total

  D. Bytes spilled to local storage

  E. Partitions scanned

  Correct Answer: BE

• Question 156:

  Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

  B. A Data Exchange allows groups of accounts to share data privately among the accounts.

  C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

  D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

  E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

  Correct Answer: B

• Question 157:

  A user has unloaded data from a Snowflake table to an external stage.

  Which command can be used to verify if data has been uploaded to the external stage named my_stage?

  A. view @my_stage

  B. list @my_stage

  C. show @my_stage

  D. display @my_stage

  Correct Answer: B

• Question 158:

  What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  A. VIEWS_HISTORY

  B. OBJECT_HISTORY

  C. ACCESS_HISTORY

  D. LOGIN_HISTORY

  Correct Answer: C

• Question 159:

  Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

  A. INSERT

  B. PUT

  C. GET

  D. COPY

  Correct Answer: D

• Question 160:

  A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

  What will occur?

  A. No virtual warehouse will be used, data will be read from the result cache.

  B. No virtual warehouse will be used, data will be read from the local disk cache.

  C. The default virtual warehouse will be used to read all data.

  D. The virtual warehouse that is defined at the session level will be used to read all data.

  Correct Answer: A