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.
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.
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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Jay_98_11
Highly Voted 1 year, 5 months agohawkhunt
Most Recent 2 months, 2 weeks agojjordan
11 months agoumidjon03
10 months, 2 weeks agoVenkataSri
11 months, 1 week agohillcat111
1 year, 3 months agoprshntdxt7
8 months agoGLEM
1 year, 3 months agoserg_khar
1 year, 6 months agoqqcvd
1 year, 6 months ago