SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ21

Manage and maintain database objects and virtual warehouses

A team is provisioning new lower environments by cloning the production database. All production objects and their references reside within the database and have no external references.

Which set of object references must be re-pointed before access is granted for use?

Explanation

When an entire database is cloned, dependencies whose referenced objects are also contained in that database are mapped to the corresponding cloned objects. This includes table defaults that use sequences and materialized views whose base tables are cloned with them. With no external references, no object reference requires manual repointing.

Learn more

Community Discussion

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