nerdexam
Snowflake

ADA-C01 · Question #69

ADA-C01 Question #69: Real Exam Question with Answer & Explanation

The correct answer is C. Sequences, storage integrations, views, secure views, and materialized views. When an object in a schema is cloned, any future grants defined for this object type in the schema are applied to the cloned object unless the COPY GRANTS option is specified in the CREATE statement for the clone operation. However, some objects may still reference the source obj

Question

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?

Options

  • ASequences, views, and secure views
  • BSequences, views, secure views, and materialized views
  • CSequences, storage integrations, views, secure views, and materialized views
  • DThere are no object references that need to be re-pointed

Explanation

When an object in a schema is cloned, any future grants defined for this object type in the schema are applied to the cloned object unless the COPY GRANTS option is specified in the CREATE statement for the clone operation. However, some objects may still reference the source object or external objects after cloning, which may cause issues with access or

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice