Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1101:

  Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy? Select one.

  A. Account-> Schema-> Database-> Table

  B. Account-> Database-> Schema-> Table

  C. Database-> Schema-> Table-> Account

  D. Database-> Table-> Schema-> Account

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 1102:

  Fail-safe is unavailable on which table types?

  A. Temporary

  B. Transient

  C. Provisional

  D. Permanent

  Correct Answer: AB

  Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

• Question 1103:

  True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 1104:

  True or False: You can define multiple columns within a clustering key on a table.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 1105:

  Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  A. The validation_mode option is used when creating an Internal Stage

  B. validation_mode=return_all_errors is a parameter of the copy command

  C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

  Correct Answer: BD

  Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

• Question 1106:

  A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? Choose 2 answers

  A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

  B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period

  C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous

  D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

  Correct Answer: BD

  The results cache will only be used if it's the same query AND the same role executing the query

• Question 1107:

  True or false: it is best practice to define a clustering key on every table.

  A. True

  B. False

  Correct Answer: B

  Reference: https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/

• Question 1108:

  How would you execute a series of SQL statements using Task?

  A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where .. INSERT INTO target2 SELECT .. FROM stream .s1 where ..

  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

  C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

  D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

  Correct Answer: C

• Question 1109:

  Which formats are supported for unloading data from Snowflake? Choose 2 answers

  A. Delimited (CSV, TSV, etc.)

  B. Avro

  C. JSON

  D. ORC

  Correct Answer: AC

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

• Question 1110:

  Which statements are true of micro-partitions? Choose 2 answers

  A. They are approximately 16MB in size

  B. They are stored compressed only if COMPRESS=TRUE on Table

  C. They are Immutable

  D. They are only encrypted in the Enterprise edition and above

  Correct Answer: AC

  Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69