IBM Big Data Engineer

1.

Which of the following Big SQL statements is valid?

CREATE TABLE t1 WITH CS; WITH t1 AS ( SELECT deptno, deptname, mgrno FROM t1WHERE admrdept ='A00'
FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

2.

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

SPSS Modeler SPSS Solution Publisher SPSS Accelerator for InfoSphere Streams None, the SPSS software runs remotely to the Streams machine

3.

Extracting structured data from various database into a "sandbox" location without writing code can be performed using which tool include with BigInsights?

Flume Data Click DataStage Big SQL Load

4.

PCI compliance requirements allow the use of real customer data during testing and development only when:

The data is only processed in memory Customer data is never allowed in testing or development The data is never stored longer than 24 hours in the test system The data is only stored in volatile storage that expires on power loss

5.

Which of the following is TRUE about a Resilient Distributed Dataset?

It is always mutable It is always immutable It can be configured to be either mutable or immutable It can be changed from mutable to immutable state during its life cycle

6.

How are insights derived from Big Match moved to an MDM system?

Extract insights from HBase and load into MDM through an API call Extract insights from Hive and load into MDM using standard tooling Extract insights from HDFS and load into MDM by stimulating delta load Extract insights from HBase and load into MDM using standard MDM batch processing tool

7.

Which of the following Pig Latin expressions is used to sum a set of numbers in a bag?

X = FOR EACH C -> (group,SUM(A.a1))

X = FOR EACH C GEN [group, SUM (A.a1)];
X = FOREACH C GENERATE group, SUM (A.a1); X = FOREACH C GENERATE FLATTEN SUM (A.a1);

8.

Which of the following statements about MapReduce is true?

MapReduce source programs must be written in Java The output from MapReduce is one or more files stored in the DFS MapReduce programs always have four phases: Mapper, Shuffle, Combiner, and Reducer Intermediate files, sent from Map tasks to Reduce tasks, are replicated with the number of copies equal to the number of Reducers

9.

Which BigInsights tool is able to export data from Big SQL?

Ambari BigSheets Flume Knox

10.

Consider the following query:
curl http://localhost:8983/sorl/gettingstarted/select?wt=json&indent=true&q=foundation&fl=id
What is the restricted field?

id json indent foundation

IBM Big Data Engineer

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Big Data Engineer

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner