SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ92

Implement Data Protection and Recovery

A Data Engineer needs to create a new development database (DEV) by cloning the permanent production database (PROD). Fail-safe must be disabled for all tables.

Which command satisfies these requirements?

Explanation

A transient database has no Fail-safe period. All schemas created in a transient database, and consequently all its tables, are transient by definition, so cloning PROD into a transient DEV database meets the requirement. DATA_RETENTION_TIME_IN_DAYS controls Time Travel retention, not Fail-safe.

Learn more

Community Discussion

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