Free Snowflake ARA-R01 Exam Questions

Question 1

A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes. What would be the MOST efficient solution?

A : Ask the partner to create a share and add the company's account.

B : Ask the partner to use the data lake export feature and place the data into cloud storage where Snowflake can natively ingest it (schema-on-read).

C : Keep the current structure but request that the partner stop changing files, instead only appending new files.

D : Ask the partner to set up a Snowflake reader account and use that account to get the data for ingestion.

Answer: A

Question 2

A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

A : Use, at minimum, the Business Critical edition of Snowflake.

B : Create Dynamic Data Masking policies and apply them to columns that contain PHI.

C : Use the Internal Tokenization feature to obfuscate sensitive data.

D : Use the External Tokenization feature to obfuscate sensitive data.

E : Rewrite SQL queries to eliminate projections of PHI data based on current_role().

F : Avoid sharing data with partner organizations.

Answer: A,B,D

Question 3

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 : 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 4

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

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Question 5

A retail company has over 3000 stores all using the same Point of Sale (POS) system. The company wants to

deliver near real-time sales results to category managers. The stores operate in a variety of time zones and

exhibit a dynamic range of transactions each minute, with some stores having higher sales volumes than

others.

Sales results are provided in a uniform fashion using data engineered fields that will be calculated in a

complex data pipeline. Calculations include exceptions, aggregations, and scoring using external functions

interfaced to scoring algorithms. The source data for aggregations has over 100M rows.

Every minute, the POS sends all sales transactions files to a cloud storage location with a naming convention

that includes store numbers and timestamps to identify the set of transactions contained in the files. The files

are typically less than 10MB in size.

How can the near real-time results be provided to the category managers? (Select TWO).

A : All files should be concatenated before ingestion into Snowflake to avoid micro-ingestion.

B : A Snowpipe should be created and configured with AUTO_INGEST = true. A stream should be created to process INSERTS into a single target table using the stream metadata to inform the store number and timestamps.

C : A stream should be created to accumulate the near real-time data and a task should be created that runs at a frequency that matches the real-time analytics needs.

D : An external scheduler should examine the contents of the cloud storage location and issue SnowSQL commands to process the data at a frequency that matches the real-time analytics needs

E : The copy into command with a task scheduled to run every second should be used to achieve the near-real time requirement.

Answer: B,C