fullSnowflake SnowPro Core Certification Complete Exam

Snowflake SnowPro Core Practice Exam with Solutions Part 2

Gonzalo Fernandez Plaza
15 min readApr 12, 2022

--

Snowflake SnowPro Core Practice Exam (Part 2).
Snowflake SnowPro Core Practice Exam (Part 2).

In the first part, we saw the first 50 questions. In this chapter, we’ll see the next 50, like in the certification exam. Best of luck both here and at the Snowflake SnowPro Core Certification test!

In case you want to refresh any theoretical concept, here you have all the chapters of the course:

QUESTIONS WITH SOLUTIONS

51: Which commands cannot be executed from the Snowflake UI?

  1. SHOW
  2. LIST <stages>
  3. GET
  4. COPY INTO
  5. PUT

Solution: 3, 5. These two commands cannot be executed from the Snowflake web interface; instead, you should use the SnowSQL client to GET or PUT data files.

52: Compute cost in Snowflake depends on…

  1. The query execution time.
  2. The query execution time and the waiting query time.
  3. The data warehouse size and for how long it runs.

Solution: 3. The cost does not depend on how many queries you run in the warehouse. It depends on which warehouse size and how long it runs.

53:What techniques would you consider to improve the performance of a query that takes a lot of time to return any result?

  1. Define partition keys
  2. Create cluster keys & turn auto clustering on the table
  3. Create an index on the search result

Solution: 2. Clustering keys are a subset of columns or expressions on a table designated to co-locate the data in the same micro-partitions. Data might become less clustered when we perform many DML operations on a table. To solve that, Snowflake also provides periodic & automatic re-clustering to maintain optimal clustering. These techniques improve the performance of…

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com