Free Access to Snowflake.ARA-C01.v2026-01-01.q152 with Valid Practice Test (Page 18)

Question 81

A company's daily Snowflake workload consists of a huge number of concurrent queries triggered between
9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company's Architect implement to enhance the performance of this workload?
(Choose two.)

A.Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
B.Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
C.Increase the size of the virtual warehouse to size X-Large.
D.Reduce the amount of data that is being processed through this workload.
E.Set the connection timeout to a higher value than its default.

Question 82

A new table and streams are created with the following commands:
CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ;
CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS;
CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY = TRUE;
The following operations are processed on the newly created table:
INSERT INTO LETTERS VALUES (1, 'A');
INSERT INTO LETTERS VALUES (2, 'B');
INSERT INTO LETTERS VALUES (3, 'C');
TRUNCATE TABLE LETTERS;
INSERT INTO LETTERS VALUES (4, 'D');
INSERT INTO LETTERS VALUES (5, 'E');
INSERT INTO LETTERS VALUES (6, 'F');
DELETE FROM LETTERS WHERE ID = 6;
What would be the output of the following SQL commands, in order?
SELECT COUNT (*) FROM STREAM_1;
SELECT COUNT (*) FROM STREAM_2;

A.2 & 6
B.2 & 3
C.4 & 3
D.4 & 6

Question 83

An Architect entered the following commands in sequence:

USER1 cannot find the table.
Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

A.GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;
B.GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;
C.GRANT ROLE PUBLIC TO ROLE INTERN;
D.GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;
E.GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

Question 84

A retail company has 2000+ stores spread across the country. Store Managers report that they are having trouble running key reports related to inventory management, sales targets, payroll, and staffing during business hours. The Managers report that performance is poor and time-outs occur frequently.
Currently all reports share the same Snowflake virtual warehouse.
How should this situation be addressed? (Select TWO).

A.Use a Business Intelligence tool for in-memory computation to improve performance.
B.Configure a dedicated virtual warehouse for the Store Manager team.
C.Configure the virtual warehouse to be multi-clustered.
D.Configure the virtual warehouse to size 4-XL
E.Advise the Store Manager team to defer report execution to off-business hours.

Question 85

The following table exists in the production database:
A regulatory requirement states that the company must mask the username for events that are older than six months based on the current date when the data is queried.
How can the requirement be met without duplicating the event data and making sure it is applied when creating views using the table or cloning the table?

A.Use a masking policy on the username column using a entitlement table with valid dates.
B.Use a row level policy on the user_events table using a entitlement table with valid dates.
C.Use a masking policy on the username column with event_timestamp as a conditional column.
D.Use a secure view on the user_events table using a case statement on the username column.

Correct Answer: C

A masking policy is a feature of Snowflake that allows masking sensitive data in query results based on the role of the user and the condition of the data. A masking policy can be applied to a column in a table or a view, and it can use another column in the same table or view as a conditional column. A conditional column is a column that determines whether the masking policy is applied or not based on its value1.
In this case, the requirement can be met by using a masking policy on the username column with event_timestamp as a conditional column. The masking policy can use a function that masks the username if the event_timestamp is older than six months based on the current date, and returns the original username otherwise. The masking policy can be applied to the user_events table, and it will also be applied when creating views using the table or cloning the table2.
The other options are not correct because:
* A. Using a masking policy on the username column using an entitlement table with valid dates would require creating another table that stores the valid dates for each username, and joining it with the user_events table in the masking policy function. This would add complexity and overhead to the masking policy, and it would not use the event_timestamp column as the condition for masking.
* B. Using a row level policy on the user_events table using an entitlement table with valid dates would require creating another table that stores the valid dates for each username, and joining it with the user_events table in the row access policy function. This would filter out the rows that have event_timestamp older than six months based on the valid dates, instead of masking the username column. This would not meet the requirement of masking the username, and it would also reduce the visibility of the event data.
* D. Using a secure view on the user_events table using a case statement on the username column would require creating a view that uses a case expression to mask the username column based on the event_timestamp column. This would meet the requirement of masking the username, but it would not be applied when cloning the table. A secure view is a view that prevents the underlying data from being exposed by queries on the view. However, a secure view does not prevent the underlying data from being exposed by cloning the table3.
References:
* 1: Masking Policies | Snowflake Documentation
* 2: Using Conditional Columns in Masking Policies | Snowflake Documentation
* 3: Secure Views | Snowflake Documentation

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File