Free Access to Snowflake.ARA-C01.v2026-04-11.q236 with Valid Practice Test (Page 45)

Question 216

A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:

Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses.
Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?

A.C5, C4, C2
B.C3, C4, C5
C.C1, C3, C2
D.C2, C1, C3

Question 217

What are some of the characteristics of result set caches? (Choose three.)

A.Time Travel queries can be executed against the result set cache.
B.Snowflake persists the data results for 24 hours.
C.Each time persisted results for a query are used, a 24-hour retention period is reset.
D.The data stored in the result cache will contribute to storage costs.
E.The retention period can be reset for a maximum of 31 days.
F.The result set cache is not shared between warehouses.

Correct Answer: B,C,E

Explanation
Comprehensive and Detailed Explanation: According to the SnowPro Advanced: Architect documents and learning resources, some of the characteristics of result set caches are:
* Snowflake persists the data results for 24 hours. This means that the result set cache holds the results of
* every query executed in the past 24 hours, and can be reused if the same query is submitted again and the underlying data has not changed1.
* Each time persisted results for a query are used, a 24-hour retention period is reset. This means that the result set cache extends the lifetime of the results every time they are reused, up to a maximum of 31 days from the date and time that the query was first executed1.
* The retention period can be reset for a maximum of 31 days. This means that the result set cache will purge the results after 31 days, regardless of whether they are reused or not. After 31 days, the next time the query is submitted, a new result is generated and persisted1.
The other options are incorrect because they are not characteristics of result set caches. Option A is incorrect because Time Travel queries cannot be executed against the result set cache. Time Travel queries use the AS OF clause to access historical data that is stored in the storage layer, not the result set cache2. Option D is incorrect because the data stored in the result set cache does not contribute to storage costs. The result set cache is maintained by the service layer, and does not incur any additional charges1. Option F is incorrect because the result set cache is shared between warehouses. The result set cache is available across virtual warehouses, so query results returned to one user are available to any other user on the system who executes the same query, provided the underlying data has not changed1. References: Using Persisted Query Results | Snowflake Documentation, Time Travel | Snowflake Documentation

Question 218

A company is designing a process for importing a large amount of loT JSON data from cloud storage into Snowflake. New sets of loT data get generated and uploaded approximately every 5 minutes.
Once the loT data is in Snowflake, the company needs up-to-date information from an external vendor to join to the data. This data is then presented to users through a dashboard that shows different levels of aggregation.
The external vendor is a Snowflake customer.
What solution will MINIMIZE complexity and MAXIMIZE performance?

A.1. Create an external table over the JSON data in cloud storage.
2. Create a task that runs every 5 minutes to run a transformation procedure on new data, based on a saved timestamp.
3. Ask the vendor to expose an API so an external function can be used to generate a call to join the data back to the loT data in the transformation procedure.
4. Give the transformed table access to the dashboard tool.
5. Perform the aggregations on the dashboard tool.
B.1. Create an external table over the JSON data in cloud storage.
2. Create a task that runs every 5 minutes to run a transformation procedure on new data based on a saved timestamp.
3. Ask the vendor to create a data share with the required data that can be imported into the company's Snowflake account.
4. Join the vendor's data back to the loT data using a transformation procedure.
5. Create views over the larger dataset to perform the aggregations required by the dashboard.
6. Give the views access to the dashboard tool.
C.1. Create a Snowpipe to bring the JSON data into Snowflake.
2. Use streams and tasks to trigger a transformation procedure when new JSON data arrives.
3. Ask the vendor to expose an API so an external function call can be made to join the vendor's data back to the loT data in a transformation procedure.
4. Create materialized views over the larger dataset to perform the aggregations required by the dashboard.
5. Give the materialized views access to the dashboard tool.
D.1. Create a Snowpipe to bring the JSON data into Snowflake.
2. Use streams and tasks to trigger a transformation procedure when new JSON data arrives.
3. Ask the vendor to create a data share with the required data that is then imported into the Snowflake account.
4. Join the vendor's data back to the loT data in a transformation procedure
5. Create materialized views over the larger dataset to perform the aggregations required by the dashboard.
6. Give the materialized views access to the dashboard tool.

Question 219

An Architect is implementing a CI/CD process. When attempting to clone a table from a production to a development environment, the cloning operation fails.
What could be causing this to happen?

A.The table is transient.
B.The table has a masking policy.
C.The retention time for the table is set to zero.
D.Tables cannot be cloned from a higher environment to a lower environment.

Question 220

A user, analyst_user has been granted the analyst_role, and is deploying a SnowSQL script to run as a background service to extract data from Snowflake.
What steps should be taken to allow the IP addresses to be accessed? (Select TWO).

A.ALTERROLEANALYST_ROLESETNETWORK_POLICY='ANALYST_POLICY';
B.ALTERUSERANALYSTJJSERSETNETWORK_POLICY='ANALYST_POLICY';
C.ALTERUSERANALYST_USERSETNETWORK_POLICY='10.1.1.20';
D.USE ROLE SECURITYADMIN;CREATE OR REPLACE NETWORK POLICY
ANALYST_POLICY ALLOWED_IP_LIST = ('10.1.1.20');
E.USE ROLE USERADMIN;CREATE OR REPLACE NETWORK POLICY
ANALYST_POLICYALLOWED_IP_LIST = ('10.1.1.20');

Question 216

Question 217

Question 218

Question 219

Question 220

Download PDF File