Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1021:

  Which statement about billing applies to Snowflake credits?

  A. Credits are billed per-minute with a 60-minute minimum

  B. Credits are used to pay for cloud data storage usage

  C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs

  D. Credits are consumed based on the warehouse size and the time the warehouse is running

  Correct Answer: D

  Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used. https:// docs.snowflake.com/en/user-guide/what-are-credits.html

• Question 1022:

  Which of the following are benefits of micro-partitioning? (Select TWO)

  A. Micro-partitions cannot overlap in their range of values

  B. Micro-partitions are immutable objects that support the use of Time Travel.

  C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

  D. Rows are automatically stored in sorted order within micro-partitions

  E. Micro-partitions can be defined on a schema-by-schema basis

  Correct Answer: BC

• Question 1023:

  Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  A. Customer-managed encryption keys through Tri-Secret Secure

  B. Automatic encryption of all data

  C. Up to 90 days of data recovery through Time Travel

  D. Object-level access control

  E. Column-level security to apply data masking policies to tables and views

  Correct Answer: BD

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 1024:

  What is the default character set used when loading CSV files into Snowflake?

  A. UTF-8

  B. UTF-16

  C. ISO S859-1

  D. ANSI_X3.A

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20 use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

• Question 1025:

  During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  A. STATEMENT_TIMEOUT__IN__SECONDS

  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  C. MAX_CONCURRENCY__LEVEL

  D. QUERY_TIMEOUT_IN_SECONDS

  Correct Answer: B

  The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter% 20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

• Question 1026:

  Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  A. VARIANT

  B. ARRAY

  C. VARCHAR

  D. XML

  E. BLOB

  Correct Answer: AB

  https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

  The maximum length of a VARIANT is 16 MB.

  A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

• Question 1027:

  What is the minimum Snowflake edition required to create a materialized view?

  A. Standard Edition

  B. Enterprise Edition

  C. Business Critical Edition

  D. Virtual Private Snowflake Edition

  Correct Answer: B

  Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require% 20Enterprise%20Edition,upgrading%2C %20please%20contact%20Snowflake%20Support.

• Question 1028:

  Which feature is only available in the Enterprise or higher editions of Snowflake?

  A. Column-level security

  B. SOC 2 type II certification

  C. Multi-factor Authentication (MFA)

  D. Object-level access control

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 1029:

  Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

  A. SCIM

  B. Federated authentication

  C. TLS 1.2

  D. Key-pair authentication

  E. OAuth

  F. OCSP authentication

  Correct Answer: BDE

• Question 1030:

  What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

  A. Informatica

  B. Power Bl

  C. Adobe

  D. Data Robot

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html