Snowflake Exam ARA-R01 Topic 2 Question 20 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 20
Topic #: 2

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?

AAsk the partner to create a share and add the company's account.

BAsk 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).

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

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

Show Suggested Answer

Suggested Answer: D

Using Snowpipe for continuous, automated data ingestion minimizes the need for manual intervention and ensures that data is available in Snowflake promptly after it is generated. Leveraging Snowflake's data sharing capabilities allows for efficient and secure access to the vendor's data without the need for complex API integrations. Materialized views provide pre-aggregated data for fast access, which is ideal for dashboards that require high performance1234.

Reference =

* Snowflake Documentation on Snowpipe4

* Snowflake Documentation on Secure Data Sharing2

* Best Practices for Data Ingestion with Snowflake1

by Justine at Sep 16, 2024, 08:46 PM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Reynalda

1 months ago

If the partner keeps changing the files, we might as well ask them to do the hokey-pokey while they're at it. This is getting more complicated than a Rubik's Cube.

upvoted 0 times

...

Albina

1 months ago

Setting up a Snowflake reader account is a good option, but it still requires some manual intervention. I'd prefer a more automated solution.

upvoted 0 times

Lezlie

5 days ago

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).

upvoted 0 times

...

Emilio

12 days ago

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

upvoted 0 times

...

Tyra

2 months ago

Keeping the current structure but asking the partner to stop changing files? That's like asking a tornado to stop spinning - it's just not practical.

upvoted 0 times

Caprice

2 days ago

B) That sounds like a good idea. It would streamline the process.

upvoted 0 times

...

Ria

4 days ago

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

upvoted 0 times

...

Man

1 months ago

C) Yeah, trying to stop the partner from changing files seems like a losing battle.

upvoted 0 times

...

Alaine

1 months ago

B) That sounds like a good idea, it would streamline the process.

upvoted 0 times

...

Glendora

1 months ago

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

upvoted 0 times

...

Jules

2 months ago

Using the data lake export feature and schema-on-read is a great idea! It's a more modern approach and reduces the overhead of managing the file structure.

upvoted 0 times

...

Sylvia

2 months ago

The partner sharing their Snowflake account seems like the most efficient solution. It eliminates the need for manual uploads and allows for seamless data integration.

upvoted 0 times