1. Home
  2. Discussions
  3. Snowflake
  4. SnowPro Advanced: Architect
  5. ARA-R01 Discussions
  6. ARA-R01 Exam Topic 4 Question 32 Discussion

Snowflake SnowPro Advanced: Architect Recertification Exam ARA-R01 Question # 32 Topic 4 Discussion

 Snowflake Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Snowflake SnowPro Advanced: Architect Recertification Exam ARA-R01 Question # 32 Topic 4 Discussion

ARA-R01 Exam Topic 4 Question 32 Discussion:
Question #: 32
Topic #: 4

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?
A.

use database db1;

use schema schemal;

create view v1 as select * from db2.schema2.table2;

B.

use database db2;

use schema schema2;

create view v2 as select * from dbl.schemal. tablel;

C.

use database db2;

use schema schema2;

select * from db1.schemal.tablel union select * from table2;

D.

use database db1;

use schema schemal;

select * from db2.schema2.table2;

Get Premium ARA-R01 Questions
Actual exam question for Snowflake ARA-R01 exam by Kai1687 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next