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

Snowflake SnowPro Advanced: Architect Certification Exam ARA-C01 Question # 25 Topic 3 Discussion

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

Snowflake SnowPro Advanced: Architect Certification Exam ARA-C01 Question # 25 Topic 3 Discussion

ARA-C01 Exam Topic 3 Question 25 Discussion:
Question #: 25
Topic #: 3

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-C01 Questions
Actual exam question for Snowflake ARA-C01 exam by Talon6697 at Aug 2, 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