SnowPro-Core Free Practice Test

- (Exam Topic 1)
When can a Virtual Warehouse start running queries?

1. A. 12am-5am
2. B. Only during administrator defined time slots
3. C. When its provisioning is complete
4. D. After replication

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

- (Exam Topic 1)
Fail-safe is unavailable on which table types?

1. A. Temporary
2. B. Transient
3. C. Provisional
4. D. Permanent

Correct Answer: AB
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

- (Exam Topic 3)
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

1. A. Create a zero-copy clone of the worksheet and grant permissions to teammates
2. B. Create a private Data Exchange so that any teammate can use the worksheet
3. C. Share the worksheet with teammates within Snowsight
4. D. Create a database and grant all permissions to teammates

Correct Answer: C

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