View Count: 0
Duration: 51 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 10
Debugging will help us find and resolve an issue in an SQL Server Integration Services (SSIS) package? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 2 of 10
You've designed a "parent" package that will execute several "child" packages.  You did  like to pass the database connection string from the parent to each of the child packages as they're run.  How will you implement the desired functionality? 
Options:
  1. By referencing the parent package's variables from the child packages using a package configuration
  2. Add the variables to be used by the child packages to the parent package's Shared Variable collection
  3. This functionality is not supported by SSIS
  4. Establish an inter-program named pipe between the packages at runtime
View Answer/Explanation:
a
Explanation:

Question No: 3 of 10
SSIS packages can be created using SQL Server Management Studio (SSMS)? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 4 of 10
When viewing data flow pipeline data using a data viewer, how can you instantly tell which transform in the SSIS pipeline last updated a specific data value? 
Options:
  1. Right click on the value and click the \view line age\ menu option
  2. By reviewing the package progress window
  3. By turning on detailed package logging and reviewing the lot after the next test run
  4. SSIS does not provide this functionality
View Answer/Explanation:
d
Explanation:

Question No: 5 of 10
A break point will pause the execution of the package at a certain point? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 6 of 10
Breakpoint can be specified at? 
Options:
  1. pre-execution or post-execution
  2. loop iteration
  3. on warning
  4. on error event of a single task container or package
  5. All the Above
View Answer/Explanation:
e
Explanation:

Question No: 7 of 10
What are  the  three basic methods for debugging the package? 
Options:
  1. Executing the package partially
  2. Debugging Control Flow tasks
  3. Debugging Data Flow task
  4. All the Above
View Answer/Explanation:
d
Explanation:

Question No: 8 of 10
How do you upgrade an SSIS Package? 
Options:
  1. Recode the package based on the functionality in SQL Server DTS
  2. Use the Migrate DTS 2000 Package wizard in BIDS then recode any portion of the package that is not accurate
  3. None the Above
View Answer/Explanation:
a b
Explanation:

Question No: 9 of 10
How many ways we can debug the control flow in SSIS? 
Options:
  1. Setting up breakpoints
  2. Using Progress tab information
  3. Using Debug windows
  4. None of the above
View Answer/Explanation:
a b c
Explanation:

Question No: 10 of 10
How many ways we can set up break points in SSIS? 
Options:
  1. 2
  2. 4
  3. 5
  4. 1
View Answer/Explanation:
a
Explanation:

  1