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
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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, 4 months agohawkhunt
Most Recent 2 weeks, 6 days agojjordan
9 months, 1 week agoumidjon03
8 months, 3 weeks agoVenkataSri
9 months, 2 weeks agohillcat111
1 year, 1 month agoprshntdxt7
6 months, 1 week agoGLEM
1 year, 1 month agoserg_khar
1 year, 4 months agoqqcvd
1 year, 4 months ago