11. Select the correct statements about parallel processing in Multiproviders.
a. Multiprovider queries create one process per info provider involved and are processed parallel by default.
b. It is not possible to make Multiprovider queries run sequential.
c. Multiprovider queries create a parent process which provides a synchronization point to collect the overall result from other sub processes.
d. Parallel processing is always faster than sequential processing in Multiproviders.
e. All of the above.
ANSWERS: A, C
Multiprovider queries create processes to run on the individual info providers involved. These processes run parallel by default. The parent process provides a synchronization point to collect overall results from sub processes. Many times the parallel processing may be slower than sequential processing, if the data volume is high.
Go back to the BI/BW quiz answer sheet
