SnowPro Advanced Architect Certification - ARA-C01 Exam Practice Test

Question 1

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group's manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

A. This scenario would actually not be possible in Snowflake - any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

B. Create a stored procedure that runs with owner's rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

C. Create a stored procedure that can be run using both caller's and owner's rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

D. Create a stored procedure that runs with caller's rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must manually download the failed file and check for errors.
Which downloading method should the Architect recommend that requires the LEAST amount of operational overhead?

A. Use the get command in SnowSQL to retrieve the file.

B. Use the Snowflake Connector for Python, connect to remote storage and download the file.

C. Use the get command in Snowsight to retrieve the file.

D. Use the Snowflake API endpoint and download the file.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

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?

A. 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.

B. Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

C. Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

D. Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

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

A. Snowflake's ability to hash keys so that hash key joins can run faster than integer joins

B. Snowflake's support of multi-table inserts into the data model's Data Vault tables

C. Data needs to be pre-partitioned to obtain a superior data access performance

D. Scaling up the virtual warehouses will support parallel processing of new source loads

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

A large table is accessed by multiple teams using point-lookup queries on different columns. Query performance is poor.
What can be done to ensure good performance for all teams?

A. Build materialized views and allow Snowflake to replace the base table.

B. Create clustering keys using a combination of all lookup columns.

C. Build multiple materialized views with cluster keys on each column.

D. Use the search optimization service on the underlying table.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?

A. The healthcare company will need to change the institute's Snowflake edition in the accounts panel.

B. Set the share_restriction parameter on the shared object to false.

C. Contact Snowflake and they will execute the share request for the healthcare company.

D. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

A company wants to configure the Client Redirect feature on their Snowflake account to ensure business continuity during failover events.
How should an Architect accomplish this?

A. Redirect client connections to another Snowflake account in a different region where the secondary account acts as the primary.

B. Redirect users' workloads and queries between available accounts.

C. Redirect connections to an available account in the closest region.

D. Enable users to log in using another Snowflake URL where replicated objects are available.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?

A. Masked data will be loaded into the new column.

B. Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.

C. Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.

D. Unmasked data will be loaded in the new column.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

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 db2;use schema schema2;create view v2 as select * from dbl.schemal. tablel;

B. use database db2;use schema schema2;select * from db1.schemal.tablel union select * from table2;

C. use database db1;use schema schemal;select * from db2.schema2.table2;

D. use database db1;use schema schemal;create view v1 as select * from db2.schema2.table2;

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Snowflake SnowPro Advanced Architect Certification - ARA-C01 Exam Practice Test

Latest Update

Useful Links

Contact Us