Which of the following examples shows a data exchange with a DB2 database by using the built-in DB2 connector?

Posted by: Pdfprep Category: C2090-101 Tags: , ,

One option to import data to your BigInsights cluster is to use Sqoop.

Which of the following examples shows a data exchange with a DB2 database by using the built-in DB2 connector?
A . $SQOOP_HOME/bin/sqoop export –connect jdbc:db2://db2.my.com:50000/myDB –username db2user –password db2pwd –table db2tbl –export-dir /sqoop/dataFile.csv
B . $SQOOP_HOME/bin/sqoop import -connect jdbc:db2://db2.my.com:50000/testdb -username db2user ­password db2pwd -table db2tbl -split-by tbl_primarykey -target-dir sqoopimports
C . $SQOOP_HOME/bin/sqoop import –connect jdbc:db2://db2.my.com:50000/testdb –username db2user –password db2pwd –table db2tbl –split-by tbl_primarykey –target-dir sqoopimports
D . $BIGINSIGHTS_HOME/bin/sqoop import –connect jdbc:db2://db2.my.com:50000/testdb — username db2user –password db2pwd –table db2tbl –split-by tbl_primarykey –target-dir sqoopimports

Answer: C

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsights.import.doc/doc/data_warehouse_sqoop.html

Leave a Reply

Your email address will not be published.