Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 601:

  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 602:

  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 603:

  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 604:

  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

• Question 605:

  Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

  A. SHOW TABLES;

  B. SHOW STORAGE BY TABLE;

  C. Information Schema-> TABLE_STORAGE_METRICS

  D. Information Schema-> TASLE_HISTORY

  Correct Answer: AC

• Question 606:

  True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

  A. True

  B. False

  Correct Answer: B

• Question 607:

  Which of the following are common use cases for zero-copy cloning? Choose 3 answers

  A. Quick provisioning of Dev and Test/QA environments

  B. Data backups

  C. Point in time snapshots

  D. Performance optimization

  Correct Answer: ABC

  Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

• Question 608:

  True or False: Data Providers can share data with only the Data Consumer.

  A. True

  B. False

  Correct Answer: B

• Question 609:

  True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

  A. True

  B. False

  Correct Answer: B

  Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

• Question 610:

  Which of the following statements is true of zero-copy cloning?

  A. Zero-copy clones objects inherit

  B. All zero-copy clone objects inherit the privileges of their original objects

  C. Zero-copy coning is licensed as an additional Snowflake feature

  D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

  Correct Answer: D

  Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data