Question

When you execute SQL statements within Integration Services, the following optimization can be made?

(a) If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance

(b) In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache

(c) If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing

(d) All of the mentioned

I got this question in an online quiz.

I'm obligated to ask this question of Integration Services in section Data Connectivity of SQL Server

Answer 1

Correct answer is (b) In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache

To explain: When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache.