nerdexam
Cloudera

DS-200 · Question #29

You have user profile records in an OLTP database that you want to join with web server logs which you have already ingested into HDFS. What is the best way to acquire the user profile for use in…

The correct answer is B. Ingest with Apache Flume D. Ingest using Sqoop. https://thinkbiganalytics.com/leading_big_data_technologies/ingestion-and-streaming-with-storm-

Plan and implement data platform resources

Question

You have user profile records in an OLTP database that you want to join with web server logs which you have already ingested into HDFS. What is the best way to acquire the user profile for use in HDFS?

Options

  • AIngest with Hadoop streaming
  • BIngest with Apache Flume
  • CIngest using Hive's LOAD DATA command
  • DIngest using Sqoop
  • EIngest using Pig's LOAD command

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    78% (21)
  • C
    11% (3)
  • E
    4% (1)

Explanation

https://thinkbiganalytics.com/leading_big_data_technologies/ingestion-and-streaming-with-storm-

Topics

#Sqoop#HDFS ingestion#OLTP to Hadoop#data acquisition

Community Discussion

No community discussion yet for this question.

Full DS-200 Practice