SnowPro Advanced: Architect Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose ACD1

  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.

• Chose ACE2

  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.

• 1

  So why E?