Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1261:

  Which commands extract the value for a key, key_1, from an object column? (Select TWO).

  A. select column:key_1 from my_table
  B. select column.key_1 from my_table
  C. select column['key_1'] from my_table
  D. select column('key_1') from my_table
  E. select key_1 from column::string as key_1
  A. select column:key_1 from my_table
  C. select column['key_1'] from my_table

  ---

  Explanation

• Question 1262:

  Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?

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

  ---

  Explanation

• Question 1263:

  While attempting to avoid data duplication, which COPY INTO option should be used to load files with expired load metadata?

  A. LOAD_UNCERTAIN_FILES
  B. FORCE
  C. VALIDATION_MODE
  D. LAST_MODIFIED
  A. LOAD_UNCERTAIN_FILES

  ---

  Explanation

  To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true. The copy option references load metadata, if available, to avoid data duplication, but also attempts to load files with expired load metadata.

• Question 1264:

  How are URLs that access unstructured data in external stages retrieved?

  A. From the Snowsight navigation menu
  B. By querying a directory table
  C. By creating an external function
  D. By using the INFORMATION_USAGE schema
  B. By querying a directory table

  ---

  Explanation

• Question 1265:

  Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  A. External Tokenization
  B. External Tables
  C. Materialized Views
  D. User-Defined Table Functions (UDTF)
  A. External Tokenization

  ---

  Explanation

• Question 1266:

  Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

  A. More micro-partitions
  B. Better query scheduling
  C. Double the numbers of servers In the compute duster
  D. Higher storage costs
  C. Double the numbers of servers In the compute duster

  ---

  Explanation

• Question 1267:

  Which cache type is used to cache data output from SQL queries?

  A. Metadata cache
  B. Result cache
  C. Remote cache
  D. Local file cache
  B. Result cache

  ---

  Explanation

  https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

• Question 1268:

  How can a Snowflake user improve long-running query performance?

  A. Reduce the virtual warehouse size.
  B. Cluster the underlying table being queried.
  C. Disable the result cache.
  D. Add ORDER BY to the query.
  B. Cluster the underlying table being queried.

  ---

  Explanation

• Question 1269:

  Which Snowflake table type persists until it is explicitly dropped, is available for all users with relevant privileges (across sessions), and has no Fail-safe period?

  A. External
  B. Permanent
  C. Temporary
  D. Transient
  D. Transient

  ---

  Explanation

• Question 1270:

  What factors affect how many credits will be charged for virtual warehouse usage? (Choose two.)

  A. Number of queries being run
  B. Number of users running queries
  C. Snow ake edition being used
  D. Size of the warehouse
  E. Length of time the warehouse runs
  D. Size of the warehouse
  E. Length of time the warehouse runs

  ---

  Explanation