Which statement is TRUE concerning optimizing the load performance?

Which statement is TRUE concerning optimizing the load performance?
A . You can improve the performance by increasing the number of map tasks assigned to the load
B . When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement
C . You can improve the performance by decreasing the number of map tasks that are assigned to the load and adjusting the heap size
D . It is advantageous to run the LOAD HADOOP statement directly pointing to large files located in the host file system as opposed to copying the files to the DFS prior to load

View Answer

Answer: A

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.3/com.ibm.swg.im.bigsql.doc/doc/bigsql_loadperf.html