Snowflake Exam ARA-R01 Topic 4 Question 19 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 19
Topic #: 4

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

Acreate schema EDW.ACCOUNTING WITH MANAGED ACCESS;

Bcreate schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS - 7;

Ccreate TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 1;

Dcreate TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;

Show Suggested Answer

Suggested Answer: D

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 users1.

Reference =

* Snowflake Documentation on creating schemas1

* Snowflake Documentation on configuring access control2

* Snowflake Documentation on understanding and viewing Fail-safe3

by Dorian at Sep 18, 2024, 05:56 PM

Limited Time Offer

25%

1 months ago

Option A seems like the way to go - it creates the schema with managed access, which is what we need.

upvoted 0 times

Anika

5 days ago

Creating a schema without fail-safe is risky, so it's good that option A includes managed access.

upvoted 0 times

...

Tamar

6 days ago

I agree, having managed access is important for security.

upvoted 0 times

...

Edda

17 days ago

Option A seems like the way to go - it creates the schema with managed access, which is what we need.

upvoted 0 times

...