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

Alibaba ACA-BigData1 Exam - Topic 7 Question 57 Discussion

Your company stores user profile records in an OLTP databases. You want to join the serecords with web server logs you have already ingested into the Hadoop file system.What is the best way to obtain and ingest these user records?
C) Ingest with sqoop import
A) Ingest with Hadoop streaming
B) Ingest using Hive
D) Ingest with Pig's LOAD command

Alibaba ACA-BigData1 Exam - Topic 7 Question 57 Discussion

Actual exam question for Alibaba's ACA-BigData1 exam
Question #: 57
Topic #: 7
[All ACA-BigData1 Questions]

Your company stores user profile records in an OLTP databases. You want to join the serecords with web server logs you have already ingested into the Hadoop file system.

What is the best way to obtain and ingest these user records?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Georgene
3 days ago
I think C is the best choice. Sqoop is designed for this.
upvoted 0 times
...
Odelia
8 days ago
I disagree, Pig's LOAD command is not efficient for this task.
upvoted 0 times
...
Sharen
13 days ago
A) Hadoop streaming seems a bit overkill for this.
upvoted 0 times
...
Dalene
18 days ago
Wait, can you really use sqoop for that? Sounds too easy!
upvoted 0 times
...
Adelle
24 days ago
I think B) Ingest using Hive could work too.
upvoted 0 times
...
Abel
29 days ago
C) Ingest with sqoop import is the way to go!
upvoted 0 times
...
Becky
1 month ago
I have a vague memory of using Hadoop streaming for some tasks, but I don't think it's the best option for this scenario. I might lean towards Sqoop as well.
upvoted 0 times
...
Henriette
1 month ago
I practiced a similar question where we had to choose between Sqoop and Hive, and I think Sqoop was the right answer because it handles imports directly from databases.
upvoted 0 times
...
Kimberlie
1 month ago
I'm not entirely sure, but I feel like Hive could be useful for querying the data after ingestion. Does that make option B a contender?
upvoted 0 times
...
Clarence
2 months ago
I think I remember that Sqoop is often used for transferring data between relational databases and Hadoop, so maybe option C is the best choice here.
upvoted 0 times
...

Save Cancel