Snowflake ARA-C01 Exam - Topic 4 Question 32 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 32
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.

* Snowflake Documentation on creating schemas1

* Snowflake Documentation on configuring access control2

* Snowflake Documentation on understanding and viewing Fail-safe3

by Elbert at Jul 14, 2024, 12:19 PM

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Danica

3 months ago

Not sure if these options really cover all scenarios.

upvoted 0 times

...

Annice

3 months ago

Definitely A, it’s straightforward and clear.

upvoted 0 times

...

Lelia

3 months ago

Wait, does "TRANSIENT" really mean no Fail-safe?

upvoted 0 times

...

Destiny

4 months ago

I think D is better, though.

upvoted 0 times

...

Laticia

4 months ago

Option C is the right choice!

upvoted 0 times

...

Xuan

4 months ago

I vaguely remember that transient schemas don’t have Fail-safe, but I’m torn between options C and D for the data retention part.

upvoted 0 times

...

Colene

4 months ago

I practiced a similar question where we had to create schemas with different access levels. I feel like "WITH MANAGED ACCESS" is key, but I’m uncertain about the specifics.

upvoted 0 times

...

Oneida

4 months ago

I think the transient schema option is important here, but I can't recall if it was option C or D that had the right data retention time.

upvoted 0 times

...

Adria

5 months ago

I remember something about managed access, but I'm not sure if it was specifically about Fail-safe.

upvoted 0 times

...

Galen

5 months ago

I'm not 100% sure, but I think option A is the best choice here. The wording seems to match the question requirements the closest.

upvoted 0 times

...

Maryann

5 months ago

I'm leaning towards option A. The "WITH MANAGED ACCESS" part seems to address the requirement about restricting object owners.

upvoted 0 times

...

Thea

5 months ago

I'm a bit confused by the "TRANSIENT" keyword in options C and D. I'm not sure if that's relevant to the requirements.

upvoted 0 times

...

Laura

5 months ago

Okay, the key things I'm looking for are creating a schema without Fail-safe and restricting object owners from passing on access. I think option A might be the right one.

upvoted 0 times

...

Shonda

5 months ago

Hmm, this looks like a tricky SQL question. I'll need to carefully read through the options and think about the requirements.

upvoted 0 times

...

Ernie

5 months ago

This seems straightforward enough. I'll go with option A since it has the interface name and true value to enable it.

upvoted 0 times

...

Jade

5 months ago

I've used AppFlow before for monitoring, but I'm not sure if that's the right tool for controlling printer access. I'll have to double-check the details.

upvoted 0 times

...