Snowflake ARA-R01 Practice Test : Free Online Preparation

Question 1
- 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.
  
  Answer: B,C,E
Question 2
- What is a key consideration when setting up search optimization service for a table?
  
  A : Search optimization service works best with a column that has a minimum of 100 K distinct values.
  
  B : Search optimization service can significantly improve query performance on partitioned external tables.
  
  C :
  Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.
  
  D : The table must be clustered with a key having multiple columns for effective search optimization.
  
  Answer: A
Question 3
- 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 :
  privileges to create or manage shares), they can add an Enterprise edition account as a consumer. This feature enables flexibility in data sharing across different Snowflake account editions, facilitating broader data collaboration and accessibility.References: Snowflake's data sharing documentation and the specifics of edition-based capabilities discussed in SnowPro Advanced: Architect certification materials. Question #:47 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? 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. 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. 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.
  
  Answer: D
Question 4
- There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel. An Architect needs to create a read-only role for certain employees working in the human resources department. Which permission sets must be granted to this role?
  
  A :
  USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
  
  B :
  USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
  
  C :
  MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
  
  D :
  USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db
  
  Answer: A
Question 5
- An Architect would like to save quarter-end financial results for the previous six years.
  Which Snowflake feature can the Architect use to accomplish this?
  
  A : Search optimization service
  
  B : Materialized view
  
  C : Time Travel
  
  D : Zero-copy cloning
  
  E : Secure views
  
  Answer: D

Free Snowflake ARA-R01 Exam Questions

Try our Free Demo Practice Tests for Comprehensive ARA-R01 Exam Preparation