MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
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 |
| Answer» C. If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing | |