View Count: 0
Duration: 25 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 course material.
Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 8
How to record package information at run time? 
Options:
  1. By using Logging option
  2. By using Event Handling
  3. All the Above
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 2 of 8
In SSIS 2012, What are the two approaches for dealing with logging  are possible? 
Options:
  1. Legacy Deployment Model
  2. Project Deployment Model
  3. All the Above
  4. None of the Above
View Answer/Explanation:
c
Explanation:

Question No: 3 of 8
SSIS has a default means to log all records updated, deleted or inserted on a per table basis? 
Options:
  1. True
  2. False
View Answer/Explanation:
b
Explanation:

Question No: 4 of 8
What is Event Handler in SSIS? 
Options:
  1. respond to raised events in your package
  2. provide ordinal relationship b/w various Items in your package
  3. It provide the functionality to your package
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 5 of 8
As per error handling in T/R, which one handle the better performance? 
Options:
  1. Like fail component
  2. redirect row
  3. All the Above
  4. None
View Answer/Explanation:
b
Explanation:

Question No: 6 of 8
Define Some Events in SSIS? 
Options:
  1. OnPostExecute
  2. OnPreExecute
  3. OnInformation
  4. OnError
View Answer/Explanation:
a b c d
Explanation:

Question No: 7 of 8
What are the  different SSIS Log Providers? 
Options:
  1. SSIS log provider for Text files
  2. SSIS log provider for Windows Event Log
  3. SSIS log provider for XML files
  4. SSIS log provider for SQL Profiler
View Answer/Explanation:
a b c d
Explanation:

Question No: 8 of 8
Explain event handlers? 
Options:
  1. To handle data validations
  2. To handle errors
  3. To handle events
  4. None
View Answer/Explanation:
c
Explanation:

  1