Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 301:

  When does a materialized view get suspended in Snowflake?

  A. When a column is added to the base table

  B. When a column is dropped from the base table

  C. When a DML operation is run on the base table

  D. When the base table is reclustered

  Correct Answer: B

• Question 302:

  What happens when a Snowflake user changes the data retention period at the schema level?

  A. All child objects will retain data for the new retention period.

  B. All child objects that do not have an explicit retention period will automatically inherit the new retention period.

  C. All child objects with an explicit retention period will be overridden with the new retention period.

  D. All explicit child object retention periods will remain unchanged.

  Correct Answer: B

  If you change the data retention period for a database or schema, the change only affects active objects contained within the database or schema. Any objects that have been dropped (for example, tables) remain unaffected.

  For example, if you have a schema s1 with a 90-day retention period and table t1 is in schema s1, table t1 inherits the 90-day retention period. If you drop table s1.t1, t1 is retained in Time Travel for 90 days. Later, if you change the schema's data retention period to 1 day, the retention period for the dropped table t1 is unchanged. Table t1 will still be retained in Time Travel for 90 days. https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-periodfor-an-object:~:text=through%20Time%20Travel.-,Note,-If%20you %20change

• Question 303:

  Which file formats support unloading semi-structured data? (Choose two.)

  A. Avro

  B. JSON

  C. ORC

  D. Parquet

  E. XML

  Correct Answer: BD

• Question 304:

  What type of function returns one value for each invocation?

  A. Aggregate

  B. Scalar

  C. Table

  D. Window

  Correct Answer: B

  https://docs.snowflake.com/en/sql-reference/functions

• Question 305:

  What is the purpose of collecting statistics on data in Snowflake?

  A. To identify data storage order correlations

  B. To enable efficient pruning based on query filters

  C. To reduce the total number of micro-partitions in a table

  D. To optimize query performance by reading all data in a table

  Correct Answer: B

• Question 306:

  Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

  A. Persisted query results

  B. QUERY_HISTORY view

  C. Query acceleration service

  D. Query Profile

  Correct Answer: D

• Question 307:

  What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

  A. Fail-safe

  B. Time Travel

  C. Cloning

  D. Account replication

  Correct Answer: A

• Question 308:

  Which function should be used to authorize users to access rows in a base table when using secure views with Secure Data Sharing?

  A. CURRENT_ACCOUNT()

  B. CURRENT_ROLE()

  C. CURRENT_SESSION()

  D. CURRENT_USER()

  Correct Answer: A

  CURRENT_ACCOUNT()

  Secure Views and Data Sharing

  When using secure views with Secure Data Sharing, use the CURRENT_ACCOUNT function to authorize users from a specific account to access rows in a base table.

  Note:

  When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions. The reason is that the owner of the data being

  shared does not typically control the users or roles in the account with which the view is being shared.

  https://docs.snowflake.com/en/user-guide/views-secure#secure-views-and-data-sharing

• Question 309:

  Snowpark provides libraries for which programming languages? (Choose two.)

  A. JavaScript

  B. Python

  C. Scala

  D. R

  E. C++

  Correct Answer: BC

  Snowpark provide libs for Java Python Scala https://docs.snowflake.com/en/developer-guide/snowpark/index#developer-guides

• Question 310:

  How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

  A. SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)

  B. SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)

  C. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)

  D. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)

  E. SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)

  Correct Answer: BE

  SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS) SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS) BE give 10 rows