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

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables. The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database. What step can be taken to improve the pruning of the reporting tables?

Options :

A : Eliminate the use of Snowpipe and load the files into internal stages using PUT commands.

B : Increase the size of the virtual warehouse to a size 5X-Large.

C : Use an ORDER BY command to load the reporting tables.

D : Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute.

Answer: C

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

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

Options :

A :

A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.

B :

If a user in the provider account with role authority to create or alter share adds an Enterprise account as a consumer, it can import the share

C :

If a user in the provider account with a share owning role sets share_restrictions to False when adding an Enterprise consumer account, it can import the share.

D :

If a user in the provider account with a share owning role which also has override share restrictions privilege share_restrictions set to False when adding an Enterprise consumer account, it can import the share.

Answer: D

Question 5

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-minute time range.

Answer: D

Higher Test Marks with Free Online ARA-R01 Exam Practice

Buying Options: