Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam ARA-R01 Topic 2 Question 20 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 20
Topic #: 2
[All ARA-R01 Questions]

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?

Show Suggested Answer Hide 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
18 days 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
20 days 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
...
Tyra
1 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
Man
16 days ago
C) Yeah, trying to stop the partner from changing files seems like a losing battle.
upvoted 0 times
...
Alaine
18 days ago
B) That sounds like a good idea, it would streamline the process.
upvoted 0 times
...
Glendora
20 days ago
A) Ask the partner to create a share and add the company's account.
upvoted 0 times
...
...
Jules
1 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
1 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
India
18 days ago
C) Keeping the current structure might cause more manual work in the long run.
upvoted 0 times
...
Emogene
21 days ago
B) That sounds like a good idea. It would definitely streamline the process.
upvoted 0 times
...
Lazaro
26 days ago
A) Ask the partner to create a share and add the company's account.
upvoted 0 times
...
...
Nieves
2 months ago
I'm not sure about option B. I think option A could also work well if the partner is willing to create a share for us.
upvoted 0 times
...
Lottie
2 months ago
I agree with Lashawna. Using the data lake export feature would definitely improve efficiency and reduce manual work.
upvoted 0 times
...
Lashawna
2 months ago
I think option B would be the most efficient solution. It would streamline the process and make it easier for Snowflake to ingest the data.
upvoted 0 times
...

Save Cancel