Free C2090-101 Exam Braindumps (page: 8)

Page 7 of 27

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

  1. Large scale machine learning
  2. Large scale graph processing
  3. Live data stream processing
  4. All of the above

Answer(s): B


Reference:

https://spark.apache.org/



Which of the following Big SQL statements is valid?

  1. CREATE TABLE t1 WITH CS;
  2. WITH t1 AS (...)
    (SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) UNION ALL (SELECT * FROM t1 WITH UR);
  3. SELECT deptno, deptname, mgrno FROM t1 WHERE admrdept =`A00' FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS
  4. ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

Answer(s): C



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

  1. Query Optimization
  2. Predicate Push down
  3. Compression efficiency
  4. Load data into DB2 and return the data

Answer(s): A


Reference:

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



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

  1. SPSS Modeler
  2. SPSS Solution Publisher
  3. SPSS Accelerator for InfoSphere Streams
  4. None, the SPSS software runs remotely to the Streams machine

Answer(s): B






Post your Comments and Discuss IBM C2090-101 exam with other Community members:

C2090-101 Discussions & Posts