Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1151:

  The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

  A. The complexity of each query

  B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

  C. The size of the data required for each query

  D. The tool that s executing the query

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 1152:

  True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

  A. True

  B. False

  Correct Answer: B

• Question 1153:

  True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 1154:

  True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

• Question 1155:

  Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

  A. Database

  B. Tables

  C. Warehouses

  D. Worksheets

  Correct Answer: ACD

  Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html

• Question 1156:

  When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: Select one.

  A. Concurrency

  B. Performance

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance

• Question 1157:

  When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

  A. Concurrency

  B. Performance

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 1158:

  What is the lowest Snowflake edition that offers Time Travel up to 90 days?

  A. standard Edition

  B. Premier Edition

  C. Enterprise Edition

  D. Business Critical Edition

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/data-availability.html

• Question 1159:

  Select the three types of tables that exist within Snowflake. Choose 3 answers

  A. Temporary

  B. Transient

  C. Provisioned

  D. Permanent

  Correct Answer: ABD

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 1160:

  True or False: During data unloading, only JSON and CSV files can be compressed.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html