Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ARA-R01 Topic 4 Question 19 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 19
Topic #: 4
[All ARA-R01 Questions]

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

Show Suggested Answer Hide 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


Contribute your Thoughts:

Delila
10 days ago
B looks good, but I'm not sure about that 'DATA_RETENTION_TIME_IN_DAYS - 7' part. Feels a little too complicated for my liking.
upvoted 0 times
...
Floyd
22 days ago
Hmm, I see your point. But I still think option A) is the best choice because it clearly mentions restricting object owners from passing on access to other users.
upvoted 0 times
...
Regenia
28 days ago
I disagree, I believe the correct answer is D) create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;
upvoted 0 times
...
Kaycee
29 days ago
I'm going with D because who doesn't love a good 'Transient' schema? It's like a secret agent for your data!
upvoted 0 times
...
Floyd
29 days ago
I think the answer is A) create schema EDW.ACCOUNTING WITH MANAGED ACCESS;
upvoted 0 times
...
Gwenn
1 months ago
C is the correct answer. The TRANSIENT keyword ensures no fail-safe, and the DATA_RETENTION_TIME_IN_DAYS = 7 restricts object owners from passing on access.
upvoted 0 times
...
Layla
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
...
...

Save Cancel