MENU
Which command will create a schema without Fail-safe and will restrict object owners from passing on access to other users?
Suggested Answer: D
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
35 comments · newest first
DA
Danica
11 months ago
Not sure if these options really cover all scenarios.
AN
Annice
11 months ago
Definitely A, it’s straightforward and clear.
LE
Lelia
11 months ago
Wait, does "TRANSIENT" really mean no Fail-safe?
DE
Destiny
11 months ago
I think D is better, though.
LA
Laticia
11 months ago
Option C is the right choice!
XU
Xuan
12 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.
CO
Colene
12 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.
ON
Oneida
12 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.
AD
Adria
1 year ago
I remember something about managed access, but I'm not sure if it was specifically about Fail-safe.
GA
Galen
1 year 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.
MA
Maryann
1 year ago
I'm leaning towards option A. The "WITH MANAGED ACCESS" part seems to address the requirement about restricting object owners.
TH
Thea
1 year 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.
LA
Laura
1 year 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.
SH
Shonda
1 year ago
Hmm, this looks like a tricky SQL question. I'll need to carefully read through the options and think about the requirements.
ER
Ernie
1 year ago
This seems straightforward enough. I'll go with option A since it has the interface name and true value to enable it.
JA
Jade
1 year 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.
LE
Leonard
2 years ago
Wait, there's a Fail-safe? I thought this was just about creating a schema. *scratches head* Anyway, A sounds good to me.
JO
Joaquin
2 years 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.
GA
Gail
2 years 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.
LU
Luis
2 years ago
Let's go with option A then, to avoid any potential issues.
KA
Kathryn
2 years ago
I think option B could also work, but option A is definitely more straightforward.
AD
Adelle
2 years ago
I agree, option A seems like the safest choice.
CA
Carmela
2 years 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.
GE
Georgiann
2 years ago
D) create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 7;
CY
Cyndy
2 years ago
C) create TRANSIENT schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS = 1;
JA
Janet
2 years ago
B) create schema EDW.ACCOUNTING WITH MANAGED ACCESS DATA_RETENTION_TIME_IN_DAYS - 7;
AZ
Azzie
2 years ago
A) create schema EDW.ACCOUNTING WITH MANAGED ACCESS;
OD
Odette
2 years ago
That makes sense, thanks for explaining.
LY
Lynsey
2 years ago
Because it mentions restricting object owners from passing on access.
OD
Odette
2 years ago
Why do you think it's C?
CO
Cora
2 years 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.
MA
Marshall
2 years ago
Yeah, it creates a schema with managed access.
JO
Jose
2 years ago
I think option A is the correct choice.
LY
Lynsey
2 years ago
I disagree, I believe the answer is C.
OD
Odette
2 years ago
I think the answer is A.