SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which of the following roles is recommended to be used to create and manage users and roles?

1. A. SYSADMIN
2. B. SECURITYADMIN
3. C. PUBLIC
4. D. ACCOUNTADMIN

Correct Answer: B
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
"Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

- (Exam Topic 2)
What happens when a cloned table is replicated to a secondary database? (Select TWO)

1. A. A read-only copy of the cloned tables is stored.
2. B. The replication will not be successful.
3. C. The physical data is replicated
4. D. Additional costs for storage are charged to a secondary account
5. E. Metadata pointers to cloned tables are replicated

Correct Answer: CD
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication and

- (Exam Topic 1)
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

1. A. Configure the Maximum Clusters setting to “Auto-Scale”
2. B. Set the Warehouse type to “Auto”
3. C. Set the Minimum Clusters and Maximum Clusters settings to the same value
4. D. Set the Minimum Clusters and Maximum Clusters settings to the different values

Correct Answer: D
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

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