ARA-C01 Question #103: Real Exam Question with Answer & Explanation

The correct answer is D: create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS. A transient schema in Snowflake is designed without a Fail-safe period, meaning it does not incur additional storage costs once it leaves Time Travel, and it is not protected by Fail-safe in the event of a data loss. The WITH MANAGED ACCESS option ensures that all privilege grant

Security and Compliance

Question

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

Options

Acreate schema EDW.ACCOUNTING WITH MANAGED ACCESS;
Bcreate schema EDW.ACCOUNTING WITH MANAGED ACCESS
Ccreate TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS
Dcreate TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS

Explanation

A transient schema in Snowflake is designed without a Fail-safe period, meaning it does not incur additional storage costs once it leaves Time Travel, and it is not protected by Fail-safe in the event of a data loss. The WITH MANAGED ACCESS option ensures that all privilege grants, including future grants on objects within the schema, are managed by the schema owner, thus restricting object owners from passing on access to other users.

Topics

#Schema management#Transient schema#Managed Access schema#Access control

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice Browse All ARA-C01 Questions