SnowPro Advanced: Architect — Question 118

An Architect has a DEV and PROD schema within a database. The DEV schema is used to create all objects with the correct permissions before promoting to the PROD schema.

The Architect wants to define a process to promote the changes made into PROD but keep the DEV environment intact for future development.

Which solution meets this requirement?

Answer options

• A. Swap SCHEMA with ALTER SCHEMA PROD SWAP WITH DEV.
• B. Create a STAGING schema which is a clone of DEV. Then ALTER SCHEMA PROD SWAP WITH STAGING.
• C. Compile a list of all the changed resources. Then CREATE OR REPLACE CLONE each DEV resource within PROD.
• D. Create a backup schema which is a clone of PROThen CREATE OR REPLACE SCHEMA PROD CLONE DEV.

Correct answer: B

Explanation

Option B is correct because creating a STAGING schema allows for a safe environment to swap with PROD, ensuring DEV remains unchanged. Option A directly swaps DEV and PROD, which doesn't keep DEV intact. Option C requires manual tracking of changes and cloning, which is less efficient. Option D incorrectly suggests cloning DEV into PROD, which does not fulfill the requirement of keeping DEV intact.