1. The following index operations require no additional disk space :
Correct Answer is : All of the mentioned
2. Which of the following index operation require additional disk space ?
Correct Answer is : DROP INDEX MOVE TO
3. The SORT_IN_TEMPDB option cannot be set for ________ statements.
Correct Answer is : DROP INDEX
4. Which of the following query will disable the index on Employee table ?
Correct Answer is : ALTER INDEX IX_Employee_OrganizationLevel_OrganizationNode Employee
5. SSMS provides different options to develop your SSIS package starting with ___________ wizard.
Correct Answer is : Import and Export
6. Point out the wrong statement :
Correct Answer is : Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
7. Which of the following is the best practice related to SSIS ?
Correct Answer is : Plan for capacity by understanding resource utilization.
8. If SSIS is not able to drive close to 100% CPU load, this may be indicative of:
Correct Answer is : Application contention
9. Point out the wrong statement :
Correct Answer is : Integration Services can be tuned beyond the speed of your source
10. The key counters for Integration Services and SQL Server are :
Correct Answer is : Process Bytes
11. _________ represents to total memory pressure on the system in SSIS.
Correct Answer is : All of the mentioned
12. The following Network perfmon counters can help you tune your topology :
Correct Answer is : Current Bandwidth
13. What do you understand by design limitation in SSIS package ?
Correct Answer is : Not making use of parallelism
14. ___________ represents how many network transfers per second are occurring.
Correct Answer is : Network Transfers
15. To increase this Rows / sec calculation in SSIS, you can do the following:
Correct Answer is : Improve drivers and driver configurations
16. Point out the correct statement :
Correct Answer is : To overcome limitations of drivers, you can try to start multiple connections to your data source
17. When you execute SQL statements within Integration Services, the following optimization can be made ?
Correct Answer is : In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
18. Which of the the following steps should be carried out using data types in SSIS for efficient results ?
Correct Answer is : Do not perform excessive casting of data types
19. Point out the wrong statement :
Correct Answer is : Heap inserts are typically slower than using a clustered index
20. Which of the following error message indicates that the package cannot run in SSIS ?
Correct Answer is : DTS_E_CANTINSERTCOLUMNTYPE