C2090-101 Online Practice Questions and Answers

Which statement is TRUE about Big SQL?

A. The table definition can include other attributes such as the primary key or check constraints

B. When using Big SQL, the CREATE TABLE statement cannot be embedded in an application program

C. If a sub-table is being defined, the authorization ID can be either the same as the owner of the root table or an equivalent

D. When defining a staging table associated with a materialized query table, the privileges held by the authorization ID of the statement only works with DBADM authority

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

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

What are the available document formats beside PDF and MS Word when export a redacted document using Optim Review Tool?

A. TIFF, and CSF

B. TIFF, and PNG

C. JPEG, and PNG

D. Plain Text, and CSV

A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical data. Which one of the following statements is true for using HiveQL?

A. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

B. It does not support nested sub-queries

C. Hive supports all ANSI SQL 2011 syntax

D. All of the above

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. MapReduce programs always have four phases: Mapper, Shuffle, Combiner, and Reducer

D. Intermediate files, sent from Map tasks to Reduce tasks, are replicated with the number of copies equal to the number of Reducers

Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?

A. InfoSphere Streams utilized Spark Streaming to interface to Hadoop

B. The HDFS operators in InfoSphere Streams use Hadoop Java APIs to access HDFS or GPFS

C. Incoming streams from InfoSphere Streams into Hadoop are not buffered to ensure low latency

D. Since InfoSphere Streams processes data in Streams tuple format, Hadoop must store the data in this format

What Redaction feature needs to be selected when manually redacting a form through the Optim Review Tool?

A. Text Redaction

B. Image Redaction

C. Region Redaction

D. Redact by Information Type

Which Big SQL file format could be expected to result in a longer running query?

A. Text

B. Avro

C. Parquet

D. Sequence_text

When indexing a Hive Table, which of the following is TRUE?

A. Hive tables do not support indexes

B. It increases query speed without the need for additional disk space

C. It does not increase query speed but makes data insert/delete/update faster

D. It increases query speed but requires additional processing time for data insert/update/delete and needs more disk space