IBM Exam C2090-101 Topic 5 Question 13 Discussion

Actual exam question for IBM's C2090-101 exam

Question #: 13
Topic #: 5

[All C2090-101 Questions]

To improve Big SQL query performance one should specify the INPUTFORMAT and OUTPUTFORMAT during which of the following?

ASELECT statements

BWhen the file is initially stored in HDFS

CCREATE and ALTER table statements

DWhile the files are accessed in your program

Show Suggested Answer

Suggested Answer: C

The Hadoop environment within the IBM InfoSphere BigInsights Version 3.0 can read a large number of storage formats. This flexibility is partially because of the INPUTFORMAT and OUTPUTFORMAT classes that you can specify on the CREATE and ALTER table statements and because of the use of installed and customized SerDe classes. The file formats listed here are available either by using explicit SQL syntax, such as STORED AS PARQUETFILE, or by using installed interfaces, such as Avro.

https://developer.ibm.com/hadoop/2014/09/19/big-sql-3-0-file-formats-usage-performance/

by Margart at May 04, 2022, 04:47 AM

Limited Time Offer

25%

Off

Get Premium C2090-101 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!