SnowPro Advanced: Data Engineer — Question 118

A Data Engineer is cloning a production database for use as a development environment using these commands:

USE ROLE CLONE_ADMIN;
CREATE DATABASE DB_DEV CLONE DE_PROD AT (OFFSET => -1800);

What must the Engineer do to ensure the cloned environment is ready to use?

Answer options

• A. Run this command on all pipes in the DB_DEV to resume loading from them: ALTER PIPESET PIPE_EXECUTION_PAUSED = FALSE;
• B. Run this command on all external stages in the DB_DEV to point them to development files: ALTER STAGESET STORAGE_INTEGRATION =;
• C. Run this command on all tables in the DB_DEV to revoke permissions from all production roles: GRANT OWNERSHIP ON ALL TABLES IN DATABASE DB_DEV TO ROLE CLONE_ADMIN REVOKE CURRENT GRANTS;
• D. Run this command on all tables with sequences in the DB_DEV to reattach the sequences to the cloned tables: ALTER TABLE.. ALTER COLUMNSET DEFAULT...NEXTVAL;

Correct answer: A

Explanation

The correct answer is A because running the command to resume loading from all pipes is necessary to ensure data is flowing into the development environment. Options B and C do not address the immediate requirement of preparing the database for use, while option D pertains to sequences, which is not a priority for the initial setup of the cloned environment.