Snowflake Exam ARA-C01 Topic 6 Question 27 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 27
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 Lenna at May 23, 2024, 08:35 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ines

6 months ago

I'm just gonna guess and hope for the best. Database permissions are like a maze of rules and exceptions, and I'm the mouse trying to find the cheese.

upvoted 0 times

...

Stephen

6 months ago

Wow, this question really tests your database permissions knowledge. I bet the exam writer had a lot of fun coming up with this one.

upvoted 0 times

Nobuko

5 months ago

C) Yeah, command D is the one that won't work for this user.

upvoted 0 times

...

Mammie

5 months ago

B) I agree, command D is the one that will fail for this user.

upvoted 0 times

...

Celestina

5 months ago

A) That's a tricky one. I think command D will fail for this user.

upvoted 0 times

...

Ronnie

6 months ago

I'm not sure, but I think Option D is the one that will fail. The user doesn't have the USAGE permission on the other database, so they can't access the table.

upvoted 0 times

Pearly

5 months ago

So, the user should stick to operations within db1 to avoid permission issues.

upvoted 0 times

...

Karma

6 months ago

Yes, that's correct. Without USAGE permission on db2, the user can't access the table.

upvoted 0 times

...

Janey

6 months ago

Option D will fail because the user doesn't have USAGE permission on db2.

upvoted 0 times

...

Charlene

6 months ago

Option C is the way to go. The user can perform a union on tables from different databases, as long as they have the necessary permissions on each table.

upvoted 0 times

...

Erick

6 months ago

I think Option A is the right choice. The user can't create a view on a table from a different database, even if they have the SELECT privilege on that table.

upvoted 0 times

Sherell

6 months ago

C) Option A is the right choice. The user can't mix tables from different databases in a select statement.

upvoted 0 times

...

Nelida

6 months ago

B) Yeah, creating a view on a table from a different database would definitely fail.

upvoted 0 times

...

Vilma

6 months ago

A) That makes sense. The user can't create a view on a table from a different database.

upvoted 0 times

...

Andree

6 months ago

Option B is definitely the correct answer. The user doesn't have the necessary permissions to create a view on a table from a different database.

upvoted 0 times

Nida

5 months ago

Yes, you're right. The user can't create a view on a table from a different database.

upvoted 0 times

...

Nida

6 months ago

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

upvoted 0 times

...

Lettie

6 months ago

Yes, you're right. The user can't create a view on a table from a different database.

upvoted 0 times

...

Mitsue

6 months ago

That makes sense. The user can't create a view on a table from a different database.

upvoted 0 times

...

Lettie

6 months ago

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

upvoted 0 times

...

Mitsue

6 months ago

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

upvoted 0 times

...