Create Next App

Exam contains 102 questions

Page 4 of 17

Question 19 🔥

Which one of the following is NOT provided by the SerDe interface?

Which database solution meets these requirements?

A. SerDe interface has to be built using C or C++ language

Highly voted

B. Allows SQL-style queries across data that is often not appropriate for a relational database

Highly voted

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

Highly voted

D. Deserializer interface takes a string or binary representation of a record, and translates it into a Java object that Big SQL can manipulate

Highly voted

Discussion of the question

Question 20 🔥

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

Which database solution meets these requirements?

A. Large scale machine learning

Highly voted

B. Large scale graph processing

Highly voted

C. Live data stream processing

Highly voted

D. All of the above

Highly voted

Discussion of the question

Question 21 🔥

Which of the following Big SQL statements is valid?

Which database solution meets these requirements?

A. CREATE TABLE t1 WITH CS;

Highly voted

B. WITH t1 AS (ג€¦) (SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) UNION ALL (SELECT * FROM t1 WITH UR);

Highly voted

C. SELECT deptno, deptname, mgrno FROM t1 WHERE admrdept ='A00' FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS

Highly voted

D. ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

Highly voted

Discussion of the question

Question 22 🔥

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

Which database solution meets these requirements?

A. Query Optimization

Highly voted

B. Predicate Push down

Highly voted

C. Compression efficiency

Highly voted

D. Load data into DB2 and return the data

Highly voted

Discussion of the question

Question 23 🔥

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

Which database solution meets these requirements?

A. SPSS Modeler

Highly voted

B. SPSS Solution Publisher

Highly voted

C. SPSS Accelerator for InfoSphere Streams

Highly voted

D. None, the SPSS software runs remotely to the Streams machine

Highly voted

Discussion of the question

Question 24 🔥

Which ONE of the following statements regarding Sqoop is TRUE?

Which database solution meets these requirements?

A. HBase is not supported as an import target

Highly voted

B. Data imported using Sqoop is always written to a single Hive partition

Highly voted

C. Sqoop can be used to retrieve rows newer than some previously imported set of rows

Highly voted

D. Sqoop can only append new rows to a database table when exporting back to a database

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_101

Exam contains 102 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us