
Answer-first summary for fast verification
Answer: Existing child objects within the database, Privileges on the schemas within the database
When cloning a database in Snowflake, the clone includes existing child objects within the database (option B) and inherits privileges on the schemas within the database (option D). This is supported by the Snowflake documentation and the community consensus, where multiple comments with high upvotes (e.g., 5 upvotes for SandipMore's explanation) confirm that cloning a database replicates all child objects and their granted privileges, but not privileges on the database itself (option A). Option C is incorrect because future child objects are not cloned, and option E is incomplete as it excludes other child objects like views or sequences. The use of 'COPY GRANTS' is not required for inheriting privileges on child objects when cloning a database or schema, as clarified in the documentation links provided in the discussion.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When cloning a database in Snowflake, which of the following objects are also cloned? (Select two.)
A
Privileges on the database
B
Existing child objects within the database
C
Future child objects within the database
D
Privileges on the schemas within the database
E
Only schemas and tables within the database
No comments yet.