SnowPro Advanced: Architect — Question 119

Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?

Answer options

• A. create schema EDW.ACCOUNTING WITH MANAGED ACCESS;
• B. create schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;
• C. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 1;
• D. create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;

Correct answer: C

Explanation

The correct answer is C because it creates a TRANSIENT schema without Fail-safe and with managed access, restricting object ownership transfer. Options A and B create regular schemas which do not meet the Fail-safe requirement, while option D specifies a longer data retention period, which is unnecessary for this scenario.