SnowPro Core Certification — Question 1047

A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.

What configuration should be used to create the schema?

Answer options

• A. Use a regular (non-managed) schema.
• B. Use a managed access schema.
• C. Use a transient schema.
• D. Set the Default_DDL_Collation parameter.

Correct answer: B

Explanation

The correct answer is B, as a managed access schema allows the owner to control access and restrict other users from granting privileges on the objects. Options A and C do not provide the necessary restrictions, and option D relates to collation settings, which do not affect privilege management.