DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ16

VerifiedOfficial exam objectives/topics

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

Which command satisfies these requirements?

Explanation

A transient database can be created with CREATE TRANSIENT DATABASE ... CLONE. All schemas and tables in a transient database are transient by definition, and transient tables have no Fail-safe period. Setting data-retention time to 0 affects Time Travel, not the Fail-safe protection of permanent tables.

Learn more

Community Discussion

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