View Count: 0
Duration: 38 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 31 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 42 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 20
What is Control Flow? 
Options:
  1. Orders the work flow of SSIS package
  2. Used to perform ETL (Extract, transform, Load) operation
  3. It encapsulates the data flow engine that moves data between sources and destinations
View Answer/Explanation:
a
Explanation:

Question No: 2 of 20
Control Flow Contains? 
Options:
  1. Tasks
  2. Container
  3. Precedence constraints
  4. All the above
View Answer/Explanation:
d
Explanation:

Question No: 3 of 20
The Data Profiling task works only with data that is stored in SQL Server. It does not work with third-party or file-based data sources? Is It true or not? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 4 of 20
You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. What should you use? 
Options:
  1. Expression task
  2. Script task
  3. Execute SQL task
  4. Execute Process task
  5. Term Extraction transformation
View Answer/Explanation:
a
Explanation:

Question No: 5 of 20
Which are valid control flow containers? 
Options:
  1. For Loop Container
  2. While Loop Container
  3. Sequence Container
  4. Generic Container
View Answer/Explanation:
a c
Explanation:

Question No: 6 of 20
Which languages can be used to code a script task? 
Options:
  1. C#.NET
  2. VB.NET
  3. T-SQL
  4. Java
View Answer/Explanation:
a b
Explanation:

Question No: 7 of 20
The SSIS task that is used to review source data entities, check the cleanliness and completeness of data and to understand how data is organized structurally is: 
Options:
  1. Script Task
  2. Data Validation Task
  3. Data Profiling Task
  4. Data Exploration Task
View Answer/Explanation:
c
Explanation:

Question No: 8 of 20
What is the function of the Read Only Variables and Read  Write Variables lists included as part of the SSIS Script Task configuration? 
Options:
  1. Only variables included in one of these lists can be referenced from a script task
  2. These lists are not a feature of the Script Task
  3. These lists are used to declare new variables that will be available to subsequent control flow tasks
View Answer/Explanation:
a
Explanation:

Question No: 9 of 20
What type of task can be used to execute the following SQL during SSIS package execution? UPDATE Production.Product SET ProductLine = 's' WHERE ProductLine IS NULL? 
Options:
  1. Data Destination Task
  2. Execute SQL Task
  3. Data Source Task
  4. SQL Server Task
View Answer/Explanation:
b
Explanation:

Question No: 10 of 20
Which Task is used to perform file and folder options such as coping, moving, deleting, creating? 
Options:
  1. Script Task
  2. Expression Task
  3. File System Task
  4. Data Exploration Task
View Answer/Explanation:
c
Explanation:

  1