C2090-101 시험 - IBM실제시험문제와 답 - 106문항

Question No : 1

Use of Bulk Load in HBase for loading large volume of data will result in which of the following?

A.It will use less CPU but will use more network resource
B.It will use less network resource but more CPU
C.It will behave same way as using HBase API for loading large volume of data
D.None of the above

정답:

Question No : 2

Which of the following statements regarding Sqoop is TRUE? (Choose two.)

A.All columns in a table must be imported
B.Sqoop bypasses MapReduce for enhanced performance
C.Each row from a source table is represented as a separate record in HDFS
D.When using a password file, the file containing the password must reside in HDFS
E.Multiple options files can be specified when invoking Sqoop from the command line

정답:
Explanation:
Reference: https://data-flair.training/blogs/apache-sqoop-tutorial/

Question No : 3

When embedding SPSS models within InfoSphere Streams, what SPSS product must be installed on the same machine with InfoSphere Streams?

A.SPSS Modeler
B.SPSS Solution Publisher
C.SPSS Accelerator for InfoSphere Streams
D.None, the SPSS software runs remotely to the Streams machine

정답:

Question No : 4

Which of the following techniques is NOT employed by Big SQL to improve performance?

A.Query Optimization
B.Predicate Push down
C.Compression efficiency
D.Load data into DB2 and return the data

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm

Question No : 5

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

정답:

Question No : 6

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

정답:
Explanation:
Reference: https://spark.apache.org/

Question No : 7

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

정답:

Question No : 8

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

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

Question No : 9

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.txt
C.hadoop fs Cput readme.txt hdfs://test.ibm.com:9000/<user>
D.hadoop fs Cput hdfs://test.ibm.com:9000/<user> readme.text

정답:

Question No : 10

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

정답:
Explanation:
Reference: http://hadooptutorial.info/apache-pig-overview/

Question No : 11

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

정답:

Question No : 12

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

정답:

Question No : 13

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

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

정답:

Question No : 14

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

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

Question No : 15

Which parameters are considered when configuring Big Match algorithm?

A.Search and custom requirements
B.Accuracy, search, and performance
C.Adaptive weighting and standardization
D.Empirical components, accuracy, and performance

정답:

IBM C2090-101 시험