Free C2090-101 Exam braindumps download (C2090-101 exam dumps Free)

Which of the following Big SQL statements is valid?

CREATE TABLE t1 WITH CS;
WITH t1 AS (...)
(SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) UNION ALL (SELECT * FROM t1 WITH UR);
SELECT deptno, deptname, mgrno FROM t1 WHERE 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

Answer(s): C

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

Answer(s): A

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?

Answer(s): B

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

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

Answer(s): C,E