Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 361:

  What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)

  A. Reduce queuing.

  B. Allow memory spillage.

  C. Increase the MAX_CONCURRENCY_LEVEL parameter.

  D. Increase the warehouse size.

  E. Suspend the warehouse frequently.

  Correct Answer: AD

  Optimizing Warehouses for Performance:

  1-Reduce queues (if WH is not multi cluster make it multi cluster else add another WH) 2-Resolve memory spillage ( scale up or convert it to Snowpark-optimized WH) 3-Increase warehouse size (Scale up) 4-Trying Query Acceleration - set

  ENABLE_QUERY_ACCELERATION = true

  5-Optimizing the Warehouse Cache (by increasing Auto-suspension)

  6-Limiting Concurrently Running Queries (Decrease the MAX_CONCURRENCY_LEVEL)

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

• Question 362:

  What entity is responsible for hosting and sharing data in Snowflake?

  A. Data provider

  B. Data consumer

  C. Reader account

  D. Managed account

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-sharing-intro#about-providers

• Question 363:

  How are privileges inherited in a role hierarchy in Snowflake?

  A. Privileges are inherited by any roles above that role in the hierarchy.

  B. Privileges are inherited by any roles at the same level in the hierarchy.

  C. Privileges are only inherited by the direct parent role in the hierarchy.

  D. Privileges are only inherited by the direct child role in the hierarchy.

  Correct Answer: A

  The privileges associated with a role are inherited by any roles above that role in the hierarchy. Do not spam with wrong answer votes

• Question 364:

  At what level can the ALLOW_CLIENT_MFA_CACHING parameter be set?

  A. Account

  B. Role

  C. Session

  D. User

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-mfa

• Question 365:

  Which Snowflake object does not consume any storage costs?

  A. Secure view

  B. Materialized view

  C. Temporary table

  D. Transient table

  Correct Answer: A

• Question 366:

  What does the LATERAL modifier for the FLATTEN function do?

  A. Casts the values of the flattened data

  B. Extracts the path of the flattened data

  C. Joins information outside the object with the flattened data

  D. Retrieves a single instance of a repeating element in the flattened data

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/querying-semistructured#using-the-flatten-function-to-parse-arrays

• Question 367:

  How can a Snowflake user validate data that is unloaded using the COPY INTO command?

  A. Load the data into a CSV file.

  B. Load the data into a relational table.

  C. Use the VALIDATION_MODE = SQL statement.

  D. Use the VALIDATION_MODE = RETURN_ROWS statement.

  Correct Answer: D

  https://community.snowflake.com/s/article/Best-Practices-for-Data-Unloading

• Question 368:

  What role in Snowflake separates the management of users and roles from the management of all grants?

  A. ACCOUNTADMIN

  B. SYSADMIN

  C. SECURITYADMIN

  D. USERADMIN

  Correct Answer: C

  https://medium.com/snowflake/role-based-access-control-rbac-with-secondary-roles-8ce3c7bb57df

• Question 369:

  Which command will unload data from a table into an external stage?

  A. PUT

  B. INSERT

  C. COPY INTO

  D. GET

  Correct Answer: C

• Question 370:

  How does Snowflake improve the performance of queries that are designed to filter out a significant amount of data?

  A. The use of indexing

  B. The use of pruning

  C. The use of TableScan

  D. By increasing the number of partitions scanned

  Correct Answer: B

  Purring improves query efficiency