Official Bank
0/157
Page
1/4
SnowPro Advanced Architect Certification (ARA-C01) - Snowflake Exam Questions
Last updated on July 22, 2026
97%
Exam Compliance
157
Total Questions
1
Question
Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would be copying of data be required, and zero-copy cloning not be suitable? (Select TWO).
Select 2
Options
A
Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.
B
Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.
C
Developers create their own datasets to work against transformed versions of the live data.
D
Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.
E
The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
2
Question
The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system.
What is the BEST way to find recent and ongoing login attempts to Snowflake?
What is the BEST way to find recent and ongoing login attempts to Snowflake?
Options
A
Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.
B
View the Users section in the Account tab in the Snowflake UI and review the last login column.
C
View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text "LOGIN".
D
Call the LOGIN_HISTORY Information Schema table function.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
3
Question
A group of Data Analysts have been granted the role analyst role. They need a Snowflake database
where they can create and modify tables, views, and other objects to load with their own data. The
Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?
where they can create and modify tables, views, and other objects to load with their own data. The
Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?
Options
A
Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.
B
Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
C
Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
D
Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
4
Question
The data share exists between a data provider account and a data consumer account. Five tables
from the provider account are being shared with the consumer account. The consumer role has been
granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?
from the provider account are being shared with the consumer account. The consumer role has been
granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?
Options
A
The consumer role will see the table only after this grant is given on the consumer side:
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;
B
The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;
grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;
grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;
C
The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;
D
The consumer role will automatically see the new table and no additional grants are needed.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
5
Question
In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).
Select 2
Options
A
Users who are schema owners can grant object privileges in a managed access schema.
B
Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.
C
Users with the SYSADMIN role can grant object privileges in a managed access schema.
D
Users who are database owners can grant object privileges in a managed access schema.
E
Users who are object owners can grant object privileges in a managed access schema.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.