Snowflake ARA-R01 Exam - 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

Trinidad

6 months ago

Not sure about D, setting up a reader account seems like extra work.

upvoted 0 times

...

Kenia

6 months ago

Totally agree with A, sharing is the way to go!

upvoted 0 times

...

Dorsey

6 months ago

Wait, can they really just stop changing files? That seems unrealistic.

upvoted 0 times

...

Chaya

7 months ago

I think B is better for scalability and flexibility.

upvoted 0 times

...

Lyda

7 months ago

Option A sounds like the easiest way to share data directly.

upvoted 0 times

...

Mireya

7 months ago

Option D sounds familiar too. I think we talked about reader accounts in our last session, but I wonder if it's really the best solution for this scenario.

upvoted 0 times

...

Trinidad

7 months ago

I'm a bit confused about option C. It seems unrealistic to ask the partner to stop changing files. That doesn't really solve the problem, right?

upvoted 0 times

...

Georgeanna

7 months ago

I think option B might be better since it allows for schema-on-read, which could simplify the ingestion process. We practiced something similar in class.

upvoted 0 times

...

Earleen

8 months ago

I remember we discussed data sharing in Snowflake, so option A seems like a good choice, but I'm not entirely sure if it's the most efficient.

upvoted 0 times

...

Scarlet

8 months ago

After reading through the question a few times, I think I'd lean towards option A or B. Those seem like the most efficient and scalable solutions, especially if the file changes are happening frequently. The other options might work in the short term, but could become more problematic as the data needs evolve.

upvoted 0 times

...

Nidia

8 months ago

I think option D is worth considering as well. Having the partner set up a Snowflake reader account could be a good way to streamline the data ingestion process and reduce the manual steps involved.

upvoted 0 times

...

Howard

8 months ago

I'm a bit confused by the question. Wouldn't keeping the current structure and just asking the partner to stop changing the files, and only append new ones, be a viable option? That's what option C is suggesting.

upvoted 0 times

...

Aliza

8 months ago

Hmm, I'm not sure about that. Option B also sounds promising, where we have the partner use the data lake export feature and place the data in cloud storage for Snowflake to ingest. That might be a bit more flexible if the file format or structure changes in the future.

upvoted 0 times

...

Rebbecca

8 months ago

This looks like a pretty straightforward question. I'd go with option A - asking the partner to create a share and add the company's account. That seems like the most efficient solution since it leverages Snowflake's native sharing capabilities.

upvoted 0 times

...

Reynalda

1 year 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 year 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

Lynelle

11 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

12 months 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 months ago

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

upvoted 0 times

...

Tyra

1 year 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

Rory

11 months ago

C) I agree, asking the partner to stop changing files is not a realistic solution.

upvoted 0 times

...

Caprice

11 months ago

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

upvoted 0 times

...

Ria

12 months ago

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

upvoted 0 times

...

Man

1 year ago

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

upvoted 0 times

...

Alaine

1 year ago

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

upvoted 0 times

...

Glendora

1 year ago

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

upvoted 0 times

...

Jules

1 year 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

1 year 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