How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Question

Options

• AShared databases are read-only.
• BShared databases must be refreshed in order for new data to be visible.
• CShared databases cannot be cloned.
• DShared databases are not supported by Time Travel.
• EShared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly
• FShared databases can also be created as transient databases.

• A
  91% (21)
• B
  4% (1)
• F
  4% (1)

Explanation

A is correct: Shared databases are read-only to consumers - they cannot INSERT, UPDATE, DELETE, or otherwise modify the provider's data. C is correct: Databases created from shares cannot be cloned; only standard (non-shared) databases support cloning. D is correct: Time Travel is not available on shared databases - consumers cannot query historical versions of shared objects using AT or BEFORE clauses. B is incorrect: Changes made by the data provider are automatically and immediately visible to consumers - no manual refresh is needed. E is incorrect: Shared databases only contain the schemas and objects explicitly granted by the provider, not automatically populated PUBLIC or INFORMATION_SCHEMA schemas. F is incorrect: Shared databases cannot be designated as transient.

No community discussion yet for this question.