Question 1

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor. What changes can be made to Improve the data loading performance?

Options :

A : Increase the size of the virtual warehouse.

B : Create a multi-cluster warehouse and merge smaller files to create bigger files.

C : Create a specific storage landing bucket to avoid file scanning.

D : Change the file format from CSV to JSON.

Answer: B

Question 2

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?

Options :

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 3

How can the Snowpipe REST API be used to keep a log of data load history?

Options :

A : Call insertReport every 20 minutes, fetching the last 10,000 entries.

B : Call loadHistoryScan every minute for the maximum time range.

C : Call insertReport every 8 minutes for a 10-minute time range.

D : Call loadHistoryScan every 10 minutes for a 15-minutes range.

Answer: D

Question 4

An Architect runs the following SQL query:How can this query be interpreted?

Options :

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

Question 5

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

Options :

A : The MERGE command

B : The UPSERT command

C : The CHANGES clause

D : A STREAM object

E : The CHANGE_DATA_CAPTURE command

Answer: C,D

Free ARA-R01 Mock Exam – Practice Online Confidently

Buying Options: