Question 21 : What do you understand by design limitation in SSIS package ?
1. Making use of parallelism
2. Not making use of parallelism
3. Package uses few single-threaded tasks
4. None of the mentioned
View Answer   Discuss with Members

Question 22 : The following Network perfmon counters can help you tune your topology :
1. Total Bandwidth
2. Current Bandwidth
3. Bandwidth bound
4. All of the mentioned
View Answer   Discuss with Members

Question 23 : _________ represents to total memory pressure on the system in SSIS.
1. Page sec
2. Page Reads
3. Memory reads
4. All of the mentioned
View Answer   Discuss with Members

Question 24 : The key counters for Integration Services and SQL Server are :
1. Process Bytes
2. Public Bytes
3. Private Set
4. All of the mentioned
View Answer   Discuss with Members

Question 25 : Point out the wrong statement :
1. SSIS moves data as fast as your network is able to handle it
2. it is important to understand your network topology and ensure that the path between your source and target have both low latency and high throughput
3. Integration Services can be tuned beyond the speed of your source
4. All of the mentioned
5.
View Answer   Discuss with Members

Question 26 : If SSIS is not able to drive close to 100% CPU load, this may be indicative of:
1. Software Contention
2. Application contention
3. Processor contention
4. None of the mentioned
View Answer   Discuss with Members

Question 27 : Which of the following is the best practice related to SSIS ?
1. Plan for capacity by understanding resource utilization.
2. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
3. Baseline source system extract speed
4. All of the mentioned
View Answer   Discuss with Members

Question 28 : Point out the wrong statement :
1. Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features
2. SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations
3. Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
4. All of the mentioned
5.
View Answer   Discuss with Members

Question 29 : SSMS provides different options to develop your SSIS package starting with ___________ wizard.
1. Import and Export
2. Copy and Import
3. Export and BulkInsert
4. None of the mentioned
View Answer   Discuss with Members

Question 30 : Two types of subscriptions present for replication is :
1. push and pull
2. throw and pull
3. push and throw
4. none of the mentioned
View Answer   Discuss with Members