SnowPro-Core Free Practice Test

- (Exam Topic 3)
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

1. A. Cloud services layer
2. B. Compute layer
3. C. Storage layer
4. D. Cloud agnostic layer

Correct Answer: B
Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

- (Exam Topic 3)
What internal stages are available in Snowflake? (Choose three.)

1. A. Schema stage
2. B. Named stage
3. C. User stage
4. D. Stream stage
5. E. Table stage
6. F. Database stage

Correct Answer: ABE

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