Snowflake ARA-R01 Exam Questions - Navigate Your Path to Success

The Snowflake SnowPro Advanced: Architect Recertification (ARA-R01) exam is a good choice and if the candidate manages to pass Snowflake SnowPro Advanced: Architect Recertification exam, he/she will earn Snowflake SnowPro Certification. Below are some essential facts for Snowflake ARA-R01 exam candidates:

TrendyCerts offers 162 Questions that are based on actual Snowflake ARA-R01 syllabus.
Our Snowflake ARA-R01 Exam Practice Questions were last updated on: Feb 27, 2025

Sample Questions for Snowflake ARA-R01 Exam Preparation

Question 1

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;

Correct : 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.

Options Selected by Other Users:

Question 2

What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

AThe use of a GET command

BThe use of a PUT command

CThe use of a ROLLBACK command

DThe use of a CALL command to a stored procedure which returns a table

ESubmitting multiple SQL statements in a single call

Correct : A, D

A. The Snowflake SQL REST API does support the use of a GET command, which can be used to retrieve the status of a previously submitted query or to fetch the results of a query once it has been executed. D. The use of a CALL command to a stored procedure is supported, which can return a result set, including a table. This allows the invocation of stored procedures within Snowflake through the SQL REST API.