SnowPro-Core Free Practice Test

- (Exam Topic 1)
True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 3)
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

1. A. Configure the user to be initially disabled.
2. B. Force an immediate password change.
3. C. Set a default role for the user.
4. D. Set the number of minutes to unlock to 15 minutes.
5. E. Set the user's access to expire within a specified timeframe.

Correct Answer: AE

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