View Count: 0
Duration: 65 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 58 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 13
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A. The package includes a data flow and is executed on Server B. The destination table has its own identity column. The destination data load has the following requirements:   ?1. The identity values from the source table must be used.?2. Default constraints on the destination table must be ignored.?3. Batch size must be 100,000 rows.   You need to add a destination and configure it to meet the requirements. Which destination should you use? 
Options:
  1. OLE DB Destination with Fast Load.
  2. ADO NET Destination without Bulk Insert.
  3. OLE DB Destination without Fast Load.
  4. SQL Server Destination.
View Answer/Explanation:
a
Explanation:

Question No: 2 of 13
How many types of SSIS connection managers are there? 
Options:
  1. 4
  2. 5
  3. 6
  4. 19
View Answer/Explanation:
d
Explanation:

Question No: 3 of 13
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the existed data in the SQL Server database through utilizing data in your data flow. Which is the correct answer? 
Options:
  1. You should utilize Data Conversion Transformation
  2. You should utilize SQL Server Destination
  3. You should utilize OLE DB Destination
  4. You should utilize Dynamic Management View (DMV)
View Answer/Explanation:
b
Explanation:

Question No: 4 of 13
What does a control flow do? 
Options:
  1. To control workflow
  2. To control events
  3. To control data flows.
  4. To control lookup
View Answer/Explanation:
a
Explanation:

Question No: 5 of 13
SSIS 2008 configuration types? 
Options:
  1. Five
  2. Four
  3. Three
  4. One
View Answer/Explanation:
a
Explanation:

Question No: 6 of 13
Which section of your package manages the overall process flow for the entire package? 
Options:
  1. Data Flow
  2. Connection Manager
  3. Control Flow
  4. Package Explorer
View Answer/Explanation:
b
Explanation:

Question No: 7 of 13
Which of the following Data Flow tasks require that the data be sorted prior to their execution? 
Options:
  1. Pivot
  2. Merge Join
  3. Conditional Split
  4. Pivot & Merge Join
View Answer/Explanation:
d
Explanation:

Question No: 8 of 13
Which of the following is not a valid Evaluation Operator for a Precedence Constraint? 
Options:
  1. Expression
  2. Constraint
  3. Variable
  4. Expression or Constraint
View Answer/Explanation:
c
Explanation:

Question No: 9 of 13
Which Data Flow Destination would be the most appropriate for sending a quick dump of data to a customer? 
Options:
  1. Raw File
  2. OLE DB
  3. Recordset
  4. Excel
View Answer/Explanation:
d
Explanation:

Question No: 10 of 13
Database maintenance tasks can be performed directly in SSIS packages. 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

  1