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 3 Question 5 Discussion

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

Role A has the following permissions:

. USAGE on db1

. USAGE and CREATE VIEW on schemal in db1

. SELECT on tablel in schemal

Role B has the following permissions:

. USAGE on db2

. USAGE and CREATE VIEW on schema2 in db2

. SELECT on table2 in schema2

A user has Role A set as the primary role and Role B as a secondary role.

What command will fail for this user?

Show Suggested Answer Hide Answer
Suggested Answer: B

This command will fail because while the user has USAGE permission on db2 and schema2 through Role B, and can create a view in schema2, they do not have SELECT permission on db1.schemal.table1 with Role B. Since Role A, which has SELECT permission on db1.schemal.table1, is not the currently active role when the view v2 is being created in db2.schema2, the user does not have the necessary permissions to read from db1.schemal.table1 to create the view. Snowflake's security model requires that the active role have all necessary permissions to execute the command.


Contribute your Thoughts:

Dorothy
10 months ago
I'm confused, but if Role A is primary, shouldn't db2 commands be tricky? I'll go with A failing.
upvoted 0 times
...
Tyra
10 months ago
I think D won't fail since it's only selecting from db2. My guess is A or B as well.
upvoted 0 times
...
Reita
10 months ago
But A involves using db1 and accessing table2 in db2.
upvoted 0 times
...
Tula
11 months ago
B sounds right. Role A doesn't have permissions on db2.
upvoted 0 times
...
Aretha
11 months ago
Really? I'm leaning towards B because it involves accessing db1 from db2.
upvoted 0 times
...
Reita
11 months ago
This question is tricky. I think the command that will fail is A.
upvoted 0 times
...
Mona
11 months ago
That's correct. The user does not have permission to select from different databases
upvoted 0 times
...
Mila
11 months ago
The command that will fail is option C
upvoted 0 times
...

Save Cancel