Question 11 : A basic package in SSIS includes the following elements
1. T-SQL flow elements
2. Control flow elements
3. DataSet flow statements
4. None of the mentioned
View Answer   Discuss with Members

Question 12 : Purpose of SQLISPackage_12546 event in SQLIS package is to :
1. Indicate that a package started
2. Indicate that a task or other executable in a package has finished its work
3. Indicate that a warning message was raised in a package
4. All of the mentioned
View Answer   Discuss with Members

Question 13 : Which of the following is event logged by the Integration Services Service ?
1. SQLISService_255
2. SQLISService_256
3. SQLISService_155
4. SQLISService_156
View Answer   Discuss with Members

Question 14 : Which of the following error message indicates that the package cannot run in SSIS ?
1. DTS_E_CANTINSERTCOLUMNTYPE
2. DTS_E_CACHELOADEDFROMFILE
3. DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN
4. DTS_E_CONNECTIONREQUIREDFORMETADATA
View Answer   Discuss with Members

Question 15 : Point out the wrong statement :
1. Heap inserts are typically slower than using a clustered index
2. Use partitions and partition SWITCH command; i.e., load a work table that contains a single partition and SWITCH it in to the main table after you build the indexes and put the constraints on
3. Use the NOLOCK or TABLOCK hints to remove locking overhead
4. Use a commit size of <5000 to avoid lock escalation when inserting; note that in SQL Server 2008 you can now enable/disable lock escalation at the
5.
View Answer   Discuss with Members

Question 16 : Which of the the following steps should be carried out using data types in SSIS for efficient results ?
1. Make data types as wide as possible so you will allocate more memory for your transformation
2. Do not perform excessive casting of data types
3. Do not watch precision issues when using the money, float, and decimal types
4. None of the mentioned
View Answer   Discuss with Members

Question 17 : When you execute SQL statements within Integration Services, the following optimization can be made ?
1. 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
2. In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
3. If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing
4. All of the mentioned
View Answer   Discuss with Members

Question 18 : Point out the correct statement :
1. If the network is your bottleneck, then a potential solution is to use single NIC card per server
2. To overcome limitations of drivers, you can try to start multiple connections to your data source
3. 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
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 19 : To increase this Rows / sec calculation in SSIS, you can do the following:
1. Improve drivers and driver configurations
2. Start single connections
3. Use single NIC cards
4. None of the mentioned
View Answer   Discuss with Members

Question 20 : ___________ represents how many network transfers per second are occurring.
1. Network Bytes
2. Network Transfers
3. Memory reads
4. None of the mentioned
View Answer   Discuss with Members