Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 91:

  How can performance be optimized for a query that returns a small amount of data from a very large base table?

  A. Use clustering keys

  B. Create materialized views

  C. Use the search optimization service

  D. Use the query acceleration service

  Correct Answer: C

• Question 92:

  Which Snowflake edition enables data sharing only through Snowflake Support?

  A. Virtual Private Snowflake

  B. Business Critical

  C. Enterprise

  D. Standard

  Correct Answer: A

• Question 93:

  What is the primary purpose of partitioning staged data files for regular data loads?

  A. To improve the performance of data loads

  B. To compress the data for efficient storage

  C. To encrypt the data for enhanced security

  D. To organize the data into subfolders for easy browsing

  Correct Answer: A

• Question 94:

  What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

  A. Standard Edition

  B. Enterprise Edition

  C. Business Critical Edition

  D. Virtual Private Snowflake Edition

  Correct Answer: C

• Question 95:

  What can a Snowflake user do to reduce queuing on a multi-cluster virtual warehouse?

  A. Increase the warehouse size.

  B. Use an economy scaling policy.

  C. Increase the maximum number of clusters.

  D. Convert the warehouse to a Snowpark-optimized warehouse.

  Correct Answer: C

• Question 96:

  What should be used to show the status of partial data loads and loading errors?

  A. The COPY_HISTORY function

  B. The QUERY_HISTORY function

  C. The ACCESS_HISTORY view

  D. The WAREHOUSE_LOAD_HISTORY function

  Correct Answer: A

• Question 97:

  What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)

  A. Column reordering

  B. Column omission

  C. JOIN function

  D. FLATTEN function

  E. GROUP BY function

  Correct Answer: AB

• Question 98:

  Which object can be used with Secure Data Sharing?

  A. View

  B. Materialized view

  C. External table

  D. User-Defined Function (UDF)

  Correct Answer: C

• Question 99:

  Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

  A. DATA_RETENTION_TIME_IN_DAYS

  B. MAX_DATA_EXTENSION_TIME_IN_DAYS

  C. MIN_DATA_RETENTION_TIME_IN_DAYS

  D. MAX_CONCURRENCY_LEVEL

  Correct Answer: C

• Question 100:

  Which commands are restricted in owner's rights stored procedures? (Choose two.)

  A. SHOW

  B. MERGE

  C. INSERT

  D. DELETE

  E. DESCRIBE

  Correct Answer: AE