DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ20

VerifiedOfficial exam objectives/topics

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

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

What must the Engineer do to make sure the cloned environment is ready for use?

Explanation

A database clone includes pipes that reference external stages, but cloned pipes are inactive by default: non-auto-ingest pipes are paused and auto-ingest pipes are in the STOPPED_CLONED state. Resuming each cloned pipe with ALTER PIPE ... SET PIPE_EXECUTION_PAUSED = FALSE enables it to process subsequent loads. Snowflake: CREATE <object> … CLONE

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!