BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake Exam ARA-C01 Topic 4 Question 32 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 32
Topic #: 4

[All ARA-C01 Questions]

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

Leonard

3 months ago

Wait, there's a Fail-safe? I thought this was just about creating a schema. *scratches head* Anyway, A sounds good to me.

upvoted 0 times

...

Joaquin

3 months ago

Option C has a weird data retention time of 1 day, that can't be right. A is the way to go, keep it simple.

upvoted 0 times

...

Gail

3 months ago

Option D includes a transient schema, which might not be what we want. I'd go with option A to be on the safe side.

upvoted 0 times

Luis

2 months ago

Let's go with option A then, to avoid any potential issues.

upvoted 0 times

...

Kathryn

2 months ago

I think option B could also work, but option A is definitely more straightforward.

upvoted 0 times

...

Adelle

2 months ago

I agree, option A seems like the safest choice.

upvoted 0 times

...

...

Carmela

3 months ago

I'm not sure about the Fail-safe part, but option A seems to be the most straightforward and secure way to create the schema.

upvoted 0 times

Georgiann

2 months ago

D) create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;

upvoted 0 times

...

Cyndy

2 months ago

C) create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 1;

upvoted 0 times

...

Janet

2 months ago

B) create schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS - 7;

upvoted 0 times

...

Azzie

2 months ago

A) create schema EDW.ACCOUNTING WITH MANAGED ACCESS;

upvoted 0 times

...

...

Odette

3 months ago

That makes sense, thanks for explaining.

upvoted 0 times

...

Lynsey

3 months ago

Because it mentions restricting object owners from passing on access.

upvoted 0 times

...

Odette

4 months ago

Why do you think it's C?

upvoted 0 times

...

Cora

4 months ago

Option A looks like the right choice. It creates a schema with managed access, which restricts object owners from passing on access to other users.

upvoted 0 times

Marshall

4 months ago

Yeah, it creates a schema with managed access.

upvoted 0 times

...

Jose

4 months ago

I think option A is the correct choice.

upvoted 0 times

...

...

Lynsey

4 months ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Odette

4 months ago

I think the answer is A.

upvoted 0 times

...