Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 341:

  Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

  A. Caching

  B. Cluster depth

  C. Query pruning

  D. Retrieval optimization

  Correct Answer: C

  https://blog.devgenius.io/snowflake-micro-partitions-clustering-keys-dbt-b6cb1212dcbe

• Question 342:

  While clustering a table, columns with which data types can be used as clustering keys? (Choose two.)

  A. BINARY

  B. GEOGRAPHY

  C. GEOMETRY

  D. OBJECT

  E. VARIANT

  Correct Answer: AC

• Question 343:

  Which use case does the search optimization service support?

  A. Disjuncts (OR) in join predicates

  B. LIKE/ILIKE/RLIKE join predicates

  C. Join predicates on VARIANT columns

  D. Conjunctions (AND) of multiple equality predicates

  Correct Answer: D

  Search optimization can improve the performance of these types of queries:

  1)Equality or IN Predicates

  2)Substrings and Regular Expressions (LIKE/ILIKE/RLIKE/CONTAINS,... )

  3)Fields in VARIANT Columns

  4)Geospatial Functions

  5)Conjunctions of Supported Predicates (AND)

  6)Disjunctions of Supported Predicates (OR)

  ----------------------------------------------------------------------------------- The search optimization service does not directly improve the performance of joins.

  https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-queries

• Question 344:

  What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

  A. BINARY_FORMAT

  B. ESCAPE_UNENCLOSED_FIELD

  C. FIELD_OPTIONALLY_ENCLOSED_BY

  D. SKIP_BYTE_ORDER_MARK

  Correct Answer: C

  Leave string fields unenclosed by setting the FIELD_OPTIONALLY_ENCLOSED_BY option to NONE (default) https://docs.snowflake.com/en/user-guide/data-unload-considerations#empty-strings-and-null-values

• Question 345:

  A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1;?

  A. The temporary table will take precedence over the permanent table.

  B. The permanent table will take precedence over the temporary table.

  C. An error will say there cannot be two tables with the same name in a schema.

  D. The table that was created most recently will take precedence over the older table.

  Correct Answer: A

  All queries and other operations performed in the session on the table affect only the temporary table https://docs.snowflake.com/en/user-guide/tables-temp-transient#potential-naming-conflicts-with-other-table-types

• Question 346:

  What information is found within the Statistic output in the Query Profile Overview?

  A. Operator tree

  B. Table pruning

  C. Most expensive nodes

  D. Nodes by execution time

  Correct Answer: B

• Question 347:

  Which roles can make grant decisions to objects within a managed access schema? (Choose two.)

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. SYSADMIN

  D. ORGADMIN

  E. USERADMIN

  Correct Answer: AB

• Question 348:

  How can a Snowflake user post-process the result of SHOW FILE FORMATS?

  A. Use the RESULT_SCAN function.

  B. Create a CURSOR for the command.

  C. Put it in the FROM clause in brackets.

  D. Assign the command to RESULTSET.

  Correct Answer: A

  first run SHOW FILE FORMATS then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1))) https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes

• Question 349:

  Which function will provide the proxy information needed to protect Snowsight?

  A. SYSTEM$GET_TAG

  B. SYSTEM$GET_PRIVATELINK

  C. SYSTEM$ALLOWLIST

  D. SYSTEM$AUTHORIZE_PRIVATELINK

  Correct Answer: C

  To determine the fully qualified URL and port for Snowsight, review the SNOWSIGHT_DEPLOYMENT entry in the return value of the SYSTEM$ALLOWLIST function. https://docs.snowflake.com/en/user-guide/ui-snowsight-gs#accessing-sf-web-interface-through-a-proxy-or-firewall

• Question 350:

  The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?

  A. User

  B. Role

  C. Account

  D. Organization

  Correct Answer: A