What set of object references needs to be re-pointed before granting access for usage?

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.

What set of object references needs to be re-pointed before granting access for usage?
A . Sequences, views, and secure views
B . Sequences, views, secure views, and materialized views
C . Sequences, storage integrations, views, secure views, and materialized views
D . There are no object references that need to be re-pointed

View Answer

Answer: D

Explanation:

When cloning is used to provision new lower environments from a production database in Snowflake, all objects (including sequences, views, secure views, and materialized views) will have the same state as in the production. The clone operation creates a fully independent copy of the database objects, meaning all references within the clone will already point to the corresponding objects within the cloned environment and do not need to be re-pointed. No object references need to be re-pointed unless those objects referenced external databases or schemas.

Therefore, if all objects and references reside within the database and do not have external references, no object references need to be re-pointed before granting access for usage.