How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
Shared databases are read-only, meaning users can view and query data but cannot insert, update, or create objects within the database. These databases also cannot be cloned, which is a key difference from standard databases. Additionally, shared databases do not support Time Travel, a feature that allows for access to historical data. These three characteristics distinctly differentiate shared databases from standard databases in Snowflake.
Should be ACD
User qqcvd provided explanation
Answer is A,D,E and is validated Explanation Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database. Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Databases created from shares differ from standard databases in the following ways: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. They cannot be cloned. Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply.
These explanation indicate answer ACD though.
So answer should be ACD right...
Answer ACD is correct
https://docs.snowflake.com/en/sql-reference/sql/create-database#general-usage-notes - Databases created from shares differ from standard databases in the following ways: - They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. - They cannot be cloned. Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply.
So why E?
The following actions are not supported: Time Travel for a shared database or any schemas/tables in the database. -> https://docs.snowflake.com/en/user-guide/data-share-consumers Databases created from shares differ from standard databases in the following ways: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. -> https://docs.snowflake.com/en/sql-reference/sql/create-database
https://docs.snowflake.com/en/sql-reference/sql/create-database#general-usage-notes ACD * Databases created from shares differ from standard databases in the following ways: * They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. * They cannot be cloned. * Properties, such as TRANSIENT and DATA_RETENTION_TIME_IN_DAYS, do not apply. In question, the statement says: E. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share. However, the fact mentioned is: They do not have the PUBLIC or INFORMATION_SCHEMA schemas unless these schemas were explicitly granted to the share. E is not correct.