IBM IBM Certifications C2090-101 Questions & Answers

• Question 81:

  Which of the following are capabilities of the Apache Spark project?

  A. Large scale machine learning

  B. Large scale graph processing

  C. Live data stream processing

  D. All of the above

  Correct Answer: B

  Reference: https://spark.apache.org/

• Question 82:

  Which of the following Big SQL statements is valid?

  A. CREATE TABLE t1 WITH CS;

  B. WITH t1 AS (...) (SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) UNION ALL (SELECT * FROM t1 WITH UR);

  C. SELECT deptno, deptname, mgrno FROM t1 WHERE admrdept =`A00' FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS

  D. ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

  Correct Answer: C

• Question 83:

  Which one of the following is NOT provided by the SerDe interface?

  A. SerDe interface has to be built using C or C++ language

  B. Allows SQL-style queries across data that is often not appropriate for a relational database

  C. Serializer takes a Java object that Big SQL has been working with, and turns it into a format that BigSQL can write to HDFS

  D. Deserializer interface takes a string or binary representation of a record, and translates it into a Java

  object that Big SQL can manipulate

  Correct Answer: A

• Question 84:

  Which of the following is the most effective method for improving query performance on large Hive tables?

  A. Indexing

  B. Bucketing

  C. Partitioning

  D. De-normalizing data

  Correct Answer: B

  Reference: https://dzone.com/articles/how-to-improve-hive-query-performance-with-hadoop

• Question 85:

  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

  Correct Answer: A

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

• Question 86:

  Given a file named readme.txt, which command will copy the readme.txt file to the directory on the HDFS?

  A. hadoop fs -cp readme.txt hdfs://test.ibm.com:9000/

  B. hadoop fs -cp hdfs://test.ibm.com:9000/ readme.txt

  C. hadoop fs -put readme.txt hdfs://test.ibm.com:9000/

  D. hadoop fs -put hdfs://test.ibm.com:9000/ readme.text

  Correct Answer: B

• Question 87:

  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

  Correct Answer: D

• Question 88:

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

  A. Text

  B. Avro

  C. RCFile

  D. Parquet

  E. Sequence_text

  Correct Answer: CD

• Question 89:

  Which statement about the Jaqi Programming Language is TRUE?

  A. Jaqi always produces a MapReduce job, but Combiner functionality is optional

  B. Jaqi includes the following operators: filter, extend, groupby, combine, and transform

  C. Data that is read from multiple blocks (splits) is always processed in parallel by MapReduce

  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

  Correct Answer: C

• Question 90:

  The GPFS implementation of Data Management API is compliant to which Open Group storage management Standard?

  A. XSH

  B. XBD

  C. XDSM

  D. X / Open

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSFKCN_4.1.0/ com.ibm.cluster.gpfs.v4r1.gpfs400.doc/bl1dmp_intro.htm