Practice ARA-R01 Exam Online

Question 1

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D

Question 2

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 3

When using the copy into < table > command with the CSV file format, how does the match_by_column_name parameter behave?

A :

It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.

B : The parameter will be ignored.

C : The command will return an error.

D : The command will return a warning stating that the file has unmatched columns.

Answer: B

Question 4

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

Question 5

An Architect runs the following SQL query:

How can this query be interpreted?

A : FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.

B : FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.

C : FILEROWS is a file. FILE_ROW_NUMBER is the file format location.

D : FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

Answer: A

Name:	SnowPro Advanced: Architect Recertification
Exam Code:	ARA-R01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	136
Last Updated:	Apr 25, 2024

Snowflake ARA-R01