SnowPro-Core Free Practice Test

- (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

- (Exam Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D

- (Exam Topic 3)
Which of the following describes a Snowflake stored procedure?

1. A. They can be created as secure and hide the underlying metadata from the user.
2. B. They can only access tables from a single database.
3. C. They can contain only a single SQL statement.
4. D. They can be created to run with a caller's rights or an owner's rights.

Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

- (Exam Topic 3)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

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

Correct Answer: BC