Snowflake: The Definitive Guide

Appendix A. Answers to the Knowledge Check Questions

Chapter 1

1. The feature to create a support case from within Snowflake is not available for trial or reader accounts. However, there are still plenty of ways to get help (see the following answer).

2. If you are unable to create a support case within Snowflake, you have several options:

   • Consult the Snowflake documentation.

   • Consult the Snowflake Knowledge Base.

   • Solicit support from the Snowflake Community.

   • Review the Stack Overflow Q&A.

   • Obtain direct support (for activation, password, billing, and cancellation requests only) from within the Snowflake Community:

     1. Log in to the Snowflake Data Heroes Community.
     2. Click the “Submit a Case” Quicklink.
     3. Select the account type “I am a 30-day trial user”.

3. Setting the context for a Snowflake worksheet means that you’ll need to let Snowflake know which role, virtual warehouse, and database you want to use in the worksheet. You can set the context through drop-down menus or with the USE statements in the worksheet (i.e., USE ROLE, USE WAREHOUSE, USE DATABASE).

4. The “Format query” option, available in the drop-down menu, gives you the ability to neatly format your SQL code. It does not correct spelling errors.

5. A Snowflake certification is valid for two years, after which time a recertification exam must be passed. Note that passing any advanced Snowflake certification resets the clock on the SnowPro core certification, so you will have two more years before you’ll need to recertify.

6. You can execute ...