SnowPro-Core Free Practice Test

- (Exam Topic 1)
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

1. A. True
2. B. False

Correct Answer: B
Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

- (Exam Topic 1)
Snowflake is designed for which type of workloads? (Choose two.)

1. A. OLAP (Analytics) workloads
2. B. OLTP (Transactional) workloads
3. C. Concurrent workloads
4. D. On-premise workloads

Correct Answer: AC
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

- (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)
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html

- (Exam Topic 2)
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

1. A. The user has the appropriate privileges on the objects associated with the query
2. B. Micro-partitions have been reclustered since the query was last run
3. C. The new query is run using the same virtual warehouse as the previous query
4. D. The query includes a User Defined Function (UDF)
5. E. The query has been run within 24 hours of the previously-run query

Correct Answer: AE