Snowflake Exam ARA-C01 Topic 6 Question 30 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 30
Topic #: 6

[All ARA-C01 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?

Ause database db1;
use schema schemal;
create view v1 as select * from db2.schema2.table2;

Buse database db2;
use schema schema2;
create view v2 as select * from dbl.schemal. tablel;

Cuse database db2;
use schema schema2;
select * from db1.schemal.tablel union select * from table2;

Duse database db1;
use schema schemal;
select * from db2.schema2.table2;

Show Suggested Answer

Suggested Answer: B

by Shanice at Jul 02, 2024, 04:08 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Christa

4 months ago

This question is like a game of 'Who Wants to be a Hacker?' Let's hope the user doesn't try to SQL-inja their way through!

upvoted 0 times

...

Hoa

5 months ago

I'm feeling confident about Option A. The user can create a view on db2.schema2.table2 since they have the necessary permissions.

upvoted 0 times

Lisbeth

3 months ago

Lawanda: Oh, I see. Thanks for clarifying!

upvoted 0 times

...

Shaniqua

4 months ago

I agree with Shaniqua, Option A should work.

upvoted 0 times

...

Lawanda

4 months ago

No, the user has the necessary permissions for that command.

upvoted 0 times

...

Colette

4 months ago

I think Option A will fail.

upvoted 0 times

...

Lynette

5 months ago

Option C looks tempting, but the user doesn't have permissions to access db1.schemal.tablel. Tricky question!

upvoted 0 times

Artie

3 months ago

C) It's a sneaky one for sure. The user is limited by their permissions, so option C would fail.

upvoted 0 times

...

Quinn

3 months ago

B) I agree, option C may seem tempting but it's a trick. The user can't access db1.schemal.tablel.

upvoted 0 times

...

Samira

3 months ago

A) That's right, the user doesn't have permissions to access db1.schemal.tablel. Tricky question indeed!

upvoted 0 times

...

Talia

4 months ago

C) It's tricky indeed, the user can't select from db2.schema2.table2 using db1.schemal, so option D will fail too.

upvoted 0 times

...

Lai

4 months ago

B) The user can't create a view using db2.schema2.table2 from db1, so option A will also fail.

upvoted 0 times

...

Lashawnda

4 months ago

A) That's right, option C will fail because the user doesn't have permissions for db1.schemal.tablel.

upvoted 0 times

...

Pamella

5 months ago

Hmm, I think Option D is the correct answer. The user can't access db2.schema2.table2 since they only have permissions on db1.

upvoted 0 times

Laila

4 months ago

Exactly, the user can only interact with db1 and schemal based on their roles.

upvoted 0 times

...

Annelle

4 months ago

So, creating a view or selecting from db2.schema2.table2 would fail for the user.

upvoted 0 times

...

Belen

4 months ago

Yes, that's right. The user's permissions are limited to db1 and schemal.

upvoted 0 times

...

Blondell

4 months ago

Option D is correct. The user can't access db2.schema2.table2 with Role A and Role B.

upvoted 0 times

...

Ellsworth

5 months ago

I believe option C will fail because the user does not have permission to select from both tables.

upvoted 0 times

...

Nicholle

5 months ago

I agree with Helga. The user does not have permission to create a view in db2.

upvoted 0 times

...

Darnell

5 months ago

Option B is a trap! The user doesn't have permissions to access db1.schemal.tablel.

upvoted 0 times

Malcolm

5 months ago

The user will fail with option B because they don't have access to db1.schemal.tablel.

upvoted 0 times

...

Malcolm

5 months ago

That's right, option B is a trap. The user doesn't have permissions for db1.schemal.tablel.

upvoted 0 times

...

Justine

5 months ago

It's a tricky one, but option B is definitely a trap. The user can't access db1.schemal.tablel.

upvoted 0 times

...

Justine

5 months ago

That's right, option B will fail because the user doesn't have permissions for db1.schemal.tablel.

upvoted 0 times

...

Helga

5 months ago

I think the command that will fail is option B.

upvoted 0 times

...