Snowflake ARA-C01 Exam Dumps

SnowPro Advanced: Architect Certification Exam

642 Reviews

Exam Code	ARA-C01
Exam Name	SnowPro Advanced: Architect Certification Exam
Questions	182 Questions Answers With Explanation
Update Date	04, 14, 2026
Price	Was : $81 Today : $45 Was : $99 Today : $55 Was : $117 Today : $65

Add To Cart

Demo Questions

Question # 1

An Architect needs to allow a user to create a database from an inbound share.To meet this requirement, the user’s role must have which privileges? (Choose two.)

A. IMPORT SHARE;  
B. IMPORT PRIVILEGES;  
C. CREATE DATABASE;  
D. CREATE SHARE;  
E. IMPORT DATABASE;  

Show Answer

Question # 2

What is a valid object hierarchy when building a Snowflake environment? 

A. Account --> Database --> Schema --> Warehouse  
B. Organization --> Account --> Database --> Schema --> Stage  
B. Organization --> Account --> Database --> Schema --> Stage  
D. Organization --> Account --> Stage --> Table --> View  

Show Answer

Question # 3

Which of the following are characteristics of how row access policies can be applied toexternal tables? (Choose three.)

A. An external table can be created with a row access policy, and the policy can be appliedto the VALUE column. 
B. A row access policy can be applied to the VALUE column of an existing external table.  
C. A row access policy cannot be directly added to a virtual column of an external table.  
D. External tables are supported as mapping tables in a row access policy.  
E. While cloning a database, both the row access policy and the external table will be cloned. 
F. A row access policy cannot be applied to a view created on top of an external table.  

Show Answer

Question # 4

A retail company has over 3000 stores all using the same Point of Sale (POS) system. Thecompany wants to deliver near real-time sales results to category managers. The storesoperate in a variety of time zones and exhibit a dynamic range of transactions each minute,with some stores having higher sales volumes than others.Sales results are provided in a uniform fashion using data engineered fields that will becalculated in a complex data pipeline. Calculations include exceptions, aggregations, andscoring using external functions interfaced to scoring algorithms. The source data foraggregations has over 100M rows.Every minute, the POS sends all sales transactions files to a cloud storage location with anaming convention that includes store numbers and timestamps to identify the set oftransactions contained in the files. The files are typically less than 10MB in size.How can the near real-time results be provided to the category managers? (Select TWO). 

A. All files should be concatenated before ingestion into Snowflake to avoid microingestion. 
B. A Snowpipe should be created and configured with AUTO_INGEST = true. A streamshould be created to process INSERTS into a single target table using the streammetadata to inform the store number and timestamps. 
C. A stream should be created to accumulate the near real-time data and a task should becreated that runs at a frequency that matches the real-time analytics needs. 
D. An external scheduler should examine the contents of the cloud storage location andissue SnowSQL commands to process the data at a frequency that matches the real-timeanalytics needs. 
E. The copy into command with a task scheduled to run every second should be used toachieve the near-real time requirement. 

Show Answer

Question # 5

An Architect with the ORGADMIN role wants to change a Snowflake account from anEnterprise edition to a Business Critical edition.How should this be accomplished?

A. Run an ALTER ACCOUNT command and create a tag of EDITION and set the tag toBusiness Critical. 
B. Use the account's ACCOUNTADMIN role to change the edition.  
C. Failover to a new account in the same region and specify the new account's editionupon creation. 
D. Contact Snowflake Support and request that the account's edition be changed.  

Show Answer

Question # 6

A company has an inbound share set up with eight tables and five secure views. Thecompany plans to make the share part of its production data pipelines.Which actions can the company take with the inbound share? (Choose two.)

A. Clone a table from a share.  
B. Grant modify permissions on the share.  
C. Create a table from the shared database.  
D. Create additional views inside the shared database.  
E. Create a table stream on the shared table.  

Show Answer

Question # 7

What is a characteristic of event notifications in Snowpipe? 

A. The load history is stored In the metadata of the target table.  
B. Notifications identify the cloud storage event and the actual data in the files.  
C. Snowflake can process all older notifications when a paused pipe Is resumed.  
D. When a pipe Is paused, event messages received for the pipe enter a limited retention period. 

Show Answer

Question # 8

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake? 

A. Privileges can be granted at the database level and can be inherited by all underlyingobjects. 
B. A user can use a "super-user" access along with securityadmin to bypass authorizationchecks and access all databases, schemas, and underlying objects. 
C. A user can create managed access schemas to support future grants and ensure onlyschema owners can grant privileges to other roles. 
D. A user can create managed access schemas to support current and future grants andensure only object owners can grant privileges to other roles. 

Show Answer

Question # 9

A retailer's enterprise data organization is exploring the use of Data Vault 2.0 to model itsdata lake solution. A Snowflake Architect has been asked to provide recommendations forusing Data Vault 2.0 on Snowflake.What should the Architect tell the data organization? (Select TWO)

A. Change data capture can be performed using the Data Vault 2.0 HASH_DIFF concept.  
B. Change data capture can be performed using the Data Vault 2.0 HASH_DELTA concept. 
C. Using the multi-table insert feature in Snowflake, multiple Point-in-Time (PIT) tables canbe loaded in parallel from a single join query from the data vault. 
D. Using the multi-table insert feature, multiple Point-in-Time (PIT) tables can be loadedsequentially from a single join query from the data vault. 
E. There are performance challenges when using Snowflake to load multiple Point-in-Time(PIT) tables in parallel from a single join query from the data vault. 

Show Answer

Question # 10

In a managed access schema, what are characteristics of the roles that can manage objectprivileges? (Select TWO).

A. Users with the SYSADMIN role can grant object privileges in a managed access schema. 
B. Users with the SECURITYADMIN role or higher, can grant object privileges in amanaged access schema. 
C. Users who are database owners can grant object privileges in a managed accessschema. 
D. Users who are schema 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.  

Show Answer

Question # 11

An Architect for a multi-national transportation company has a system that is used to checkthe weather conditions along vehicle routes. The data is provided to drivers.The weather information is delivered regularly by a third-party company and thisinformation is generated as JSON structure. Then the data is loaded into Snowflake in acolumn with a VARIANT data type. Thistable is directly queried to deliver the statistics to the drivers with minimum time lapse.A single entry includes (but is not limited to):- Weather condition; cloudy, sunny, rainy, etc.- Degree- Longitude and latitude- Timeframe- Location address- WindThe table holds more than 10 years' worth of data in order to deliver the statistics fromdifferent years and locations. The amount of data on the table increases every day.The drivers report that they are not receiving the weather statistics for their locations intime.What can the Architect do to deliver the statistics to the drivers faster?

A. Create an additional table in the schema for longitude and latitude. Determine a regulartask to fill this information by extracting it from the JSON dataset. 
B. Add search optimization service on the variant column for longitude and latitude in orderto query the information by using specific metadata. 
C. Divide the table into several tables for each year by using the timeframe informationfrom the JSON dataset in order to process the queries in parallel. 
D. Divide the table into several tables for each location by using the location addressinformation from the JSON dataset in order to process the queries in parallel. 

Show Answer

Question # 12

A Developer is having a performance issue with a Snowflake query. The query receives upto 10 different values for one parameter and then performs an aggregation over themajority of a fact table. It thenjoins against a smaller dimension table. This parameter value is selected by the differentquery users when they execute it during business hours. Both the fact and dimensiontables are loaded with new data in an overnight import process.On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance isacceptable on a size Large or bigger warehouse. However, there is no budget to increasecosts. The Developerneeds a recommendation that does not increase compute costs to run this query.What should the Architect recommend?

A. Create a task that will run the 10 different variations of the query corresponding to the 10different parameters before the users come in to work. The query results will then becached and ready to respond quickly when the users re-issue the query. 
B. Create a task that will run the 10 different variations of the query corresponding to the 10different parameters before the users come in to work. The task will be scheduled to alignwith the users' working hours in order to allow the warehouse cache to be used. 
C. Enable the search optimization service on the table. When the users execute the query,the search optimization service will automatically adjust the query execution plan based onthe frequently-used parameters. 
D. Create a dedicated size Large warehouse for this particular set of queries. Create a newrole that has USAGE permission on this warehouse and has the appropriate readpermissions over the fact and dimension tables. Have users switch to this role and use thiswarehouse when they want to access this data. 

Show Answer

Question # 13

A new user user_01 is created within Snowflake. The following two commands areexecuted:Command 1 SHOW GRANTS TO USER user_01;Command 2 SHOW GRANTS ON USER user_01;What inferences can be made about these commands? 

A. Command 1 defines which user owns user_01Command 2 defines all the grants whichhave been given to user_01 
B. Command 1 defines all the grants which are given to user_01Command 2 defines whichuser owns user_01 
C. Command 1 defines which role owns user_01Command 2 defines all the grants whichhave been given to user_01 
D. Command 1 defines all the grants which are given to user_01Command 2 defines whichrole owns user_01 

Show Answer

Question # 14

Which statements describe characteristics of the use of materialized views in Snowflake?(Choose two.)

A. They can include ORDER BY clauses.  
B. They cannot include nested subqueries.  
C. They can include context functions, such as CURRENT_TIME().  
D. They can support MIN and MAX aggregates.  
E. They can support inner joins, but not outer joins.  

Show Answer

Question # 15

How can the Snowflake context functions be used to help determine whether a user isauthorized to see data that has column-level security enforced? (Select TWO).

A. Set masking policy conditions using current_role targeting the role in use for the current session. 
B. Set masking policy conditions using is_role_in_session targeting the role in use for thecurrent account. 
C. Set masking policy conditions using invoker_role targeting the executing role in a SQL statement. 
D. Determine if there are ownership privileges on the masking policy that would allow theuse of any function. 
E. Assign the accountadmin role to the user who is executing the object.  

Show Answer

Question # 16

A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. Thecompany stores its marketing data in a Snowflake database named MARKET_DB. One ofthe company’s business partners has an account named PARTNERB in Azure East US 2region. For marketing purposes the company has agreed to share the databaseMARKET_DB with the partner account.Which of the following steps MUST be performed for the account PARTNERB to consumedata from the MARKET_DB database? 

A. Create a new account (called AZABC123) in Azure East US 2 region. From accountACCOUNTA create a share of database MARKET_DB, create a new database out of thisshare locally in AWS us-east-1 region, and replicate this new database to AZABC123account. Then set up data sharing to the PARTNERB account. 
B. From account ACCOUNTA create a share of database MARKET_DB, and create a newdatabase out of this share locally in AWS us-east-1 region. Then make this database theprovider and share it with the PARTNERB account. 
C. Create a new account (called AZABC123) in Azure East US 2 region. From accountACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account setup the data sharing to the PARTNERB account. 
D. Create a share of database MARKET_DB, and create a new database out of this sharelocally in AWS us-east-1 region. Then replicate this database to the partner’s accountPARTNERB. 

Show Answer

Question # 17

A company has several sites in different regions from which the company wants to ingestdata.Which of the following will enable this type of data ingestion?

A. The company must have a Snowflake account in each cloud region to be able to ingestdata to that account. 
B. The company must replicate data between Snowflake accounts.  
C. The company should provision a reader account to each site and ingest the datathrough the reader accounts. 
D. The company should use a storage integration for the external stage.  

Show Answer

Question # 18

When loading data from stage using COPY INTO, what options can you specify for theON_ERROR clause?

A. CONTINUE  
B. SKIP_FILE  
C. ABORT_STATEMENT  
D. FAIL  

Show Answer

Question # 19

A DevOps team has a requirement for recovery of staging tables used in a complex set ofdata pipelines. The staging tables are all located in the same staging schema. One of therequirements is to have online recovery of data on a rolling 7-day basis.After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certaintables remain unrecoverable past 1 day.What would cause this to occur? (Choose two.)

A. The staging schema has not been setup for MANAGED ACCESS.  
B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.
C. The tables exceed the 1 TB limit for data recovery.  
D. The staging tables are of the TRANSIENT type.  
E. The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema. 

Show Answer

Question # 20

A company’s client application supports multiple authentication methods, and is using Okta.What is the best practice recommendation for the order of priority when applicationsauthenticate to Snowflake?

A. 1) OAuth (either Snowflake OAuth or External OAuth)2) External browser3) Okta nativeauthentication4) Key Pair Authentication, mostly used for service account users5)Password 
B. 1) External browser, SSO2) Key Pair Authentication, mostly used for developmentenvironment users3) Okta native authentication4) OAuth (ether Snowflake OAuth orExternal OAuth)5) Password 
C. 1) Okta native authentication2) Key Pair Authentication, mostly used for productionenvironment users3) Password4) OAuth (either Snowflake OAuth or External OAuth)5)External browser, SSO 
D. 1) Password2) Key Pair Authentication, mostly used for production environment users3)Okta native authentication4) OAuth (either Snowflake OAuth or External OAuth)5) Externalbrowser, SSO 

Show Answer

Question # 21

Files arrive in an external stage every 10 seconds from a proprietary system. The filesrange in size from 500 K to 3 MB. The data must be accessible by dashboards as soon asit arrives.How can a Snowflake Architect meet this requirement with the LEAST amount of coding?(Choose two.)

A. Use Snowpipe with auto-ingest.  
B. Use a COPY command with a task.  
C. Use a materialized view on an external table.  
D. Use the COPY INTO command.  
E. Use a combination of a task and a stream.  

Show Answer

Question # 22

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RYfunction. The Architect observes that the COMPILATIONJHME is greater than theEXECUTIONJTIME.What is the reason for this?

A. The query is processing a very large dataset.  
B. The query has overly complex logic.  
C. The query is queued for execution.  
D. The query is reading from remote storage.  

Show Answer

Question # 23

What Snowflake system functions are used to view and or monitor the clustering metadatafor a table? (Select TWO).

A. SYSTEMSCLUSTERING  
B. SYSTEMSTABLE_CLUSTERING  
C. SYSTEMSCLUSTERING_DEPTH  
D. SYSTEMSCLUSTERING_RATIO  
E. SYSTEMSCLUSTERING_INFORMATION  

Show Answer

Question # 24

What Snowflake features should be leveraged when modeling using Data Vault? 

A. Snowflake’s support of multi-table inserts into the data model’s Data Vault tables  
B. Data needs to be pre-partitioned to obtain a superior data access performance  
C. Scaling up the virtual warehouses will support parallel processing of new source loads  
D. Snowflake’s ability to hash keys so that hash key joins can run faster than integer joins  

Show Answer

Question # 25

Which steps are recommended best practices for prioritizing cluster keys in Snowflake?(Choose two.)

A. Choose columns that are frequently used in join predicates.  
B. Choose lower cardinality columns to support clustering keys and cost effectiveness.  
C. Choose TIMESTAMP columns with nanoseconds for the highest number of uniquerows. 
D. Choose cluster columns that are most actively used in selective filters.  
E. Choose cluster columns that are actively used in the GROUP BY clauses.  

Show Answer