C2090-101

Which of the following are CRUD operations available in HBase? (Choose two.)A . HTable.PutB . HTable.ReadC . HTable.DeleteD . HTable.UpdateE . HTable.RemoveView AnswerAnswer: AC Explanation: Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm

Which of the following is not a capability of Pig?A . Low-latency queriesB . Schemas are optionalC . Nested relational data modelD . A high level abstraction on top of MapReduceView AnswerAnswer: A Explanation: Reference: http://hadooptutorial.info/apache-pig-overview/

Which statement is TRUE about Big SQL?A . The table definition can include other attributes such as the primary key or check constraintsB . When using Big SQL, the CREATE TABLE statement cannot be embedded in an application programC . If a sub-table is being defined, the authorization ID can...

Which statement is TRUE concerning optimizing the load performance?A . You can improve the performance by increasing the number of map tasks assigned to the loadB . When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statementC . You...

Which one of the following is NOT provided by the SerDe interface?A . SerDe interface has to be built using C or C++ languageB . Allows SQL-style queries across data that is often not appropriate for a relational databaseC . Serializer takes a Java object that Big SQL has been...

Given a file named readme.txt, which command will copy the readme.txt file to the <user> directory on the HDFS?A . hadoop fs Ccp readme.txt hdfs://test.ibm.com:9000/<user>B . hadoop fs Ccp hdfs://test.ibm.com:9000/<user> readme.txtC . hadoop fs Cput readme.txt hdfs://test.ibm.com:9000/<user>D . hadoop fs Cput hdfs://test.ibm.com:9000/<user> readme.textView AnswerAnswer: B

When we create a new table in Hive, which clause can be used in HiveSQL to indicate the storage file format?A . SAVE ASB . MAKE ASC . FORMAT ASD . STORED ASView AnswerAnswer: D

Which of the following techniques is NOT employed by Big SQL to improve performance?A . Query OptimizationB . Predicate Push downC . Compression efficiencyD . Load data into DB2 and return the dataView AnswerAnswer: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm

Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?A . InfoSphere Streams can both read from and write data to HDFSB . The Streams Big Data toolkit operators that interface with HDFS uses Apache Flume to integrate with HadoopC . Streams applications never...

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...