fullSnowflake SnowPro Core Certification Complete Exam
Snowflake SnowPro Core Practice Exam with Solutions 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?
- SHOW
- LIST <stages>
- GET
- COPY INTO
- 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…
- The query execution time.
- The query execution time and the waiting query time.
- 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?
- Define partition keys
- Create cluster keys & turn auto clustering on the table
- 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…