SnowPro Advanced: Architect — Question 62

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Choose two.)

Answer options

• A. Any pipes in the source are not cloned.
• B. Any pipes in the source referring to internal stages are not cloned.
• C. Any pipes in the source referring to external stages are not cloned.
• D. The clone inherits all granted privileges of all child objects in the source object, including the database.
• E. The clone inherits all granted privileges of all child objects in the source object, excluding the database.

Correct answer: B, E

Explanation

Option B is correct because pipes that refer to internal stages are not included in the cloning process, which can affect the functionality of the cloned database. Option E is also correct as it states that the clone does not inherit privileges related to the database itself, ensuring that certain security measures are maintained. The other options are incorrect as they either misstate the cloning process or do not pertain to the correct considerations for database cloning.