Question 1

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

Options :

A : CONTINUE

B : SKIP_FILE

C : ABORT_STATEMENT

D : FAIL

Answer: A,B,C

Question 2

How can the Snowpipe REST API be used to keep a log of data load history?

Options :

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minute time range.

Answer: D

Question 3

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

Options :

A : Create multiple clustering keys for a table.

B : Create multiple materialized views with different cluster keys.

C : Create super projections that will automatically create clustering.

D : Create a clustering key that contains all columns used in the access paths.

Answer: B

Question 4

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?

Options :

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

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

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

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

Answer: C

Question 5

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

Options :

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Free ARA-R01 Mock Exam – Practice Online Confidently

Buying Options: