Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Architect · Snowflake
Select 3 answers.
This question asks for 3 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
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.
So why E?