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 import -connect jdbc:db2://db2.my.com:50000/testdb -username db2user - password db2pwd -table db2tbl -split-by tbl_primarykey -target-dir sqoopimports
B. $SQOOP_HOME/bin/sqoop export --connect jdbc:db2://db2.my.com:50000/myDB --username db2user -- password db2pwd --table db2tbl --export-dir /sqoop/dataFile.csv
C. $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
D. $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
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Which of the following Hive data types is directly supported in Big SQL without any changes?
A. INT
B. STRUCT
C. STRING
D. BOOLEAN
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Which of the following statements about MapReduce is true?
A. MapReduce source programs must be written in Java
B. The output from MapReduce is one or more files stored in the DFS
C. Intermediate files, sent from Map tasks to Reduce tasks, are replicated with the number of copies equal to the number of Reducers
D. MapReduce programs always have four phases: Mapper, Shuffle, Combiner, and Reducer
正解:B
質問 4:
Which of the following is the most effective method for improving query performance on large Hive tables?
A. Bucketing
B. Indexing
C. Partitioning
D. De-normalizing data
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
Which statement about the Jaqi Programming Language is TRUE?
A. Jaqi always produces a MapReduce job, but Combiner functionality is optional
B. Data that is read from multiple blocks (splits) is always processed in parallel by MapReduce
C. Jaqi includes the following operators: filter, extend, groupby, combine, and transform
D. The read operator loads data from different source and formats, and then converts this data into JSON format for internal processing by the Jaqi interpreter
正解:B
質問 6:
What are the key elements that IBM Big Match Probabilistic Matching Engine leverages?
A. Phonetics and nicknames
B. Phonetics and searching
C. Wildcard and sorting
D. Wildcard and phonetics
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
A large Telecom company wants to store data from multiple databases into Hadoop. They plan to do bulk loads of data into Hadoop and run analytical queries. Which data store would be ideal for this scenario?
A. Hive
B. Apache Spark
C. HBase
D. BigSheets
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?
A. expand
B. transform
C. join
D. group
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
瑠川** -
C2090-101必要となる基礎を幅広く習得させたいという思いでした。C2090-101問題集の問題はなぜか本番試験にほぼ出てて、高いスコアで合格するには十分ですね。