Question

Point out the correct statement.

(a) If the network is your bottleneck, then a potential solution is to use a single NIC card per server

(b) To overcome the limitations of drivers, you can try to start multiple connections to your data source

(c) For 64-bit systems, at design time you may be loading 32-bit drivers; ensure that at run time you are using 32-bit drivers

(d) None of the mentioned

I have been asked this question during a job interview.

I need to ask this question from Integration Services topic in chapter Data Connectivity of SQL Server

Answer 1

The correct answer is (b) To overcome the limitations of drivers, you can try to start multiple connections to your data source

For explanation I would say: As long as the source can handle many concurrent connections, you may see an increase in throughput if you start several extracts at once.