IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 11:

  What command is used to find the version level of GPFS running on a particular Linux node?

  A. lslpp -ver \*
  B. list ver gpfs\*
  C. lslpp -l gpfs\*
  D. rpm -qa | grep gpfs
  D. rpm -qa | grep gpfs

  ---

  Reference: https://www.google.com/url?sa=tandrct=jandq=andesrc=sandsource=webandcd=3andved=2ahUKEwjKhrG7q_foAhXiVhUIHSizDyQQFjACegQIAxABandurl=https%3A%2F%2Fwww.ibm.com%2Fdeveloperworks%2Fcommunity%2Fforums% 2Fatom%2Fdownload%2FConcepts_Planning_Installation.pdf%3FnodeId%3Df189c262-a09f-4ed0-991b-3e702fafcad2andusg=AOvVaw32QxwHaqCkUPwVyWiS01Cx (11)

• Question 12:

  Which of the following is TRUE regarding a schema In Jaql?

  A. It specifies a particular type for each field
  B. It is used only when Jaql includes SQL statements
  C. It must be provided when the data format is not otherwise known
  D. It can be used both as a data constraint and to optimize processing and storage
  B. It is used only when Jaql includes SQL statements

• Question 13:

  Which of the following statements is TRUE regarding the use of Data Click to load data into BigInsights?

  A. Data Click uses Map Reduce to create a Hive table
  B. Only relational databases are supported as sources for Data Click
  C. Only whole tables can be moved from a relational database source, not individual columns within the table
  D. If the metadata that you specify in InfoSphere Data Click activities changes, you need to reimport the metadata by using InfoSphere Metadata Asset Manager
  D. If the metadata that you specify in InfoSphere Data Click activities changes, you need to reimport the metadata by using InfoSphere Metadata Asset Manager

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.dataclick.doc/topics/createblueprint.html

• Question 14:

  Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?

  A. join
  B. group
  C. expand
  D. transform
  B. group

  ---

  Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJandpg=PA174andlpg=PA174anddq=Jaq+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate

  +expressionandsource=blandots=zobr8AZzWyandsig=ZRCIH9ee4Un3Aam1hX8TzxfrfQIandhl=enandsa=Xandredir_esc=y#v=onepageandq=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key%20values%20and% 20applies%20an%20aggregate%20expressionandf=false

• Question 15:

  Which of the following is most commonly used by Hadoop to move data between clusters?

  A. Pig
  B. FTP
  C. JAQL
  D. distcp
  D. distcp

  ---

  Reference: https://developer.ibm.com/hadoop/2016/02/05/fast-can-data-transferred-hadoop-clusters-using-distcp/

• Question 16:

  Which Big SQL statement can be used to store a single row into an HBase table?

  A. LOAD HIVE DATA
  B. INSERT INTO HBASE
  C. CREATE HBASE TABLE
  D. LOAD USING ... INTO HBASE TABLE
  B. INSERT INTO HBASE

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsights.bigsql.doc/doc/bsql_insert.html

• Question 17:

  Which of the following is not a capability of Pig?

  A. Low-latency queries
  B. Schemas are optional
  C. Nested relational data model
  D. A high level abstraction on top of MapReduce
  A. Low-latency queries

  ---

  Reference: http://hadooptutorial.info/apache-pig-overview/

• Question 18:

  Which file format support Column data compression? (Choose two.)

  A. Text
  B. Avro
  C. RCFile
  D. Parquet
  E. Sequence_text
  C. RCFile
  D. Parquet

• Question 19:

  When we create a new table in Hive, which clause can be used in HiveSQL to indicate the storage file format?

  A. SAVE AS
  B. MAKE AS
  C. FORMAT AS
  D. STORED AS
  D. STORED AS

• Question 20:

  To improve Big SQL query performance one should specify the INPUTFORMAT and OUTPUTFORMAT during which of the following?

  A. SELECT statements
  B. When the file is initially stored in HDFS
  C. CREATE and ALTER table statements
  D. While the files are accessed in your program
  C. CREATE and ALTER table statements

  ---

  The Hadoop environment within the IBM?InfoSphere BigInsights Version 3.0 can read a large number of storage formats. This flexibility is partially because of the INPUTFORMAT and OUTPUTFORMAT classes that you can specify on the CREATE and ALTER table statements and because of the use of installed and customized SerDe classes. The file formats listed here are available either by using explicit SQL syntax, such as STORED AS PARQUETFILE, or by using installed interfaces, such as Avro.

  Reference: https://developer.ibm.com/hadoop/2014/09/19/big-sql-3-0-file-formats-usage-performance/