SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ48

Secure Data Sharing and Consumption

Which command creates a schema without Fail-safe while preventing object owners from granting access to other users?

Explanation

A transient schema has no Fail-safe period. A managed access schema centralizes privilege grants with the schema owner, so object owners cannot grant privileges on their objects to other roles. Transient schemas allow DATA_RETENTION_TIME_IN_DAYS of 0 or 1, making a setting of 1 valid.

Learn more

Community Discussion

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