SnowPro Advanced: Architect — Question 2

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Answer options

• A. Shared databases are read-only.
• B. Shared databases must be refreshed in order for new data to be visible.
• C. Shared databases cannot be cloned.
• D. Shared databases are not supported by Time Travel.
• E. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
• F. Shared databases can also be created as transient databases.

Correct answer: A, C, D

Explanation

The correct answers are A, C, and D because shared databases in Snowflake are indeed read-only, cannot be cloned, and do not support Time Travel features. Options B and E are incorrect since shared databases automatically reflect new data without a refresh and include certain schemas by default, while option F is irrelevant to the differences outlined.