SnowPro-Core Free Practice Test

- (Exam Topic 3)
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

1. A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
2. B. Scaling out adds clusters of varying sizes to a virtual warehouse.
3. C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
4. D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
5. E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
6. F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Correct Answer: AE

- (Exam Topic 3)
How often are the Account and Table master keys automatically rotated by Snowflake?

1. A. 30 Days
2. B. 60 Days
3. C. 90 Days
4. D. 365 Days.

Correct Answer: D

- (Exam Topic 2)
What is the minimum Snowflake edition required to create a materialized view?

1. A. Standard Edition
2. B. Enterprise Edition
3. C. Business Critical Edition
4. D. Virtual Private Snowflake Edition

Correct Answer: B
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized views%

- (Exam Topic 2)
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

1. A. STATEMENT_TIMEOUT__IN__SECONDS
2. B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
3. C. MAX_CONCURRENCY LEVEL
4. D. QUERY_TIMEOUT_IN_SECONDS

Correct Answer: B
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
sets the limit for a query to wait in
the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text

- (Exam Topic 1)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

1. A. Growth of storage and compute are tightly coupled together
2. B. Storage expands without the requirement to add more compute
3. C. Compute can be scaled up or down without the requirement to add more storage
4. D. Multiple compute clusters can access stored data without contention

Correct Answer: BCD
Reference:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt
separate-storage-and-compute-65d2dffd450f