SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which of the following objects is not covered by Time Travel?

1. A. Tables
2. B. Schemas
3. C. Databases
4. D. Stages

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

- (Exam Topic 2)
What is the default File Format used in the COPY command if one is not specified?

1. A. CSV
2. B. JSON
3. C. Parquet
4. D. XML

Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

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