Your company stores user profile records in an OLTP databases. You want to join these records
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?
A.
Ingest with Hadoop streaming
B.
Ingest using Hive’s IQAD DATA command
C.
Ingest with sqoop import
D.
Ingest with Pig’s LOAD command
E.
Ingest using the HDFS put command
Only C is the correct answer.
0
0
what is the correct answer?
0
0
Answer : C
0
0
C…sqoop is used import data from OLTP to HDFS.
0
0
C
0
0
C
0
0
I choose CD
0
0
You have the latest exam?
0
0
Answer: C
You need to join User profile records and weblogs. Weblogs is already ingested into HDFS.So in order to join weblogs with user profile,we need to bring user profile also into HDFS. User profile is residing in OLPT database so to import that to HDFS we need the help of SQOOP.
Ref: stackoverflow
0
0