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
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.
2
Question
A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis. This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days. The company wants to centralize access control, provide a single point of connection for the end- users, and maintain data governance.
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?
Options
A
Import the data used for reporting into a Snowflake schema with native tables. Then create views
that have SELECT commands pointing to the cloud storage files for the experimentation data. Then create two different roles to match the different user personas, and grant these roles to the corresponding users.
that have SELECT commands pointing to the cloud storage files for the experimentation data. Then create two different roles to match the different user personas, and grant these roles to the corresponding users.
B
Import all the data in cloud storage to be used for reporting into a Snowflake schema with native
tables. Then create a role that has access to this schema and manage access to the data through that role.
tables. Then create a role that has access to this schema and manage access to the data through that role.
C
Import the data used for reporting into a Snowflake schema with native tables. Then create
external tables pointing to the cloud storage folders used for the experimentation data. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
external tables pointing to the cloud storage folders used for the experimentation data. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
D
Import all the data in cloud storage to be used for reporting into a Snowflake schema with native
tables. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
tables. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
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
The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization
What Snowflake data modeling approaches will meet these requirements? (Choose two.)
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization
What Snowflake data modeling approaches will meet these requirements? (Choose two.)
Select 2
Options
A
Create a single star schema in a single database to support all consumers’ requirements.
B
Create a raw database for landing and persisting raw data entering the data pipelines.
C
Create a set of profile-specific databases that aligns data with usage patterns.
D
Consolidate data in the company’s data lake and use EXTERNAL TABLES.
E
Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.
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
What integration object should be used to place restrictions on where data may be exported?
Options
A
Security integration
B
API integration
C
Storage integration
D
Stage integration
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
How can the Snowpipe REST API be used to keep a log of data load history?
Options
A
Call loadHistoryScan every 10 minutes for a 15-minutes range.
B
Call loadHistoryScan every minute for the maximum time range.
C
Call insertReport every 8 minutes for a 10-minute time range.
D
Call insertReport every 20 minutes, fetching the last 10,000 entries.
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.