SnowPro-Core Free Practice Test

- (Exam Topic 1)
True or False: It is possible to load data into Snowflake without creating a named File Format object.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

- (Exam Topic 3)
Which of the following is a data tokenization integration partner?

1. A. Protegrity
2. B. Tableau
3. C. DBeaver
4. D. SAP

Correct Answer: A

- (Exam Topic 3)
Which statement is true about running tasks in Snowflake?

1. A. A task can be called using a CALL statement to run a set of predefined SQL commands.
2. B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
3. C. A task allows a user to execute a set of SQL commands on a predefined schedule.
4. D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer: C

- (Exam Topic 3)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

1. A. 4
2. B. 8
3. C. 16
4. D. 32

Correct Answer: B
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

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