Discussion :: SQL Server MCQs
- 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
|
Whatsapp
Facebook
Answer : Option B
Explanation :
When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache.
Be The First To Comment