Cloudera
CCA-500 · Question #46
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…
The correct answer is C. Ingest with sqoop import. See the full explanation below for the reasoning.
Question
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?
Options
- AIngest with Hadoop streaming
- BIngest using Hive's IQAD DATA command
- CIngest with sqoop import
- DIngest with Pig's LOAD command
- EIngest using the HDFS put command
How the community answered
(38 responses)- A3% (1)
- B5% (2)
- C76% (29)
- D13% (5)
- E3% (1)
Community Discussion
No community discussion yet for this question.