View Count: 0
Duration: 44 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 33 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 9
What SSIS feature enables you to use a different database connection string on a production server that is used during development? 
Options:
  1. Package Configurations
  2. The SSIS .properties file
  3. The Control Flow s configuration tab
  4. Package Execution Profiles
View Answer/Explanation:
a
Explanation:

Question No: 2 of 9
What is the purpose of a package checkpoint? 
Options:
  1. Package checkpoints enable package restartability
  2. If running the package in the debugger, package checkpoints stop package execution at the designated checkpoint
  3. Package checkpoints allow you to roll-back package design changes to a previous version of the package
  4. Package checkpoints are not a feature of SSIS packages
View Answer/Explanation:
a
Explanation:

Question No: 3 of 9
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load. The package and all three   Execute SQL product tasks have their Transaction Option property set to Supported. You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes. What should you do? 
Options:
  1. Change the Transaction Option property of the package to Required.
  2. Change the Transaction Option property of all three Execute SQL product tasks to Required.
  3. Move the three Execute SQL product tasks into a For each Loop container.
  4. Move the three Execute SQL product tasks into a Sequence container.
View Answer/Explanation:
a
Explanation:

Question No: 4 of 9
For what data checkpoint data is not saved? 
Options:
  1. For Each Loop containers
  2. For Loop containers.
  3. While Loop Container
  4. Sequence Container
View Answer/Explanation:
a b
Explanation:

Question No: 5 of 9
Mention what are the possible locations to save SSIS package? 
Options:
  1. SQL Server
  2. Package Store
  3. File System
View Answer/Explanation:
a b c
Explanation:

Question No: 6 of 9
Parameters are how many types in SSIS? 
Options:
  1. 2
  2. 4
  3. 3
  4. 6
View Answer/Explanation:
a
Explanation:

Question No: 7 of 9
Parameters allow you to assign values to properties within packages at the time of package execution? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 8 of 9
You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes  Execute  SQL tasks. To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do this, you want to alter the transaction Option property of the package. Which of the following is the value that must be set for the TransactionOption property of the package? 
Options:
  1. NotSupported.
  2. Supported.
  3. NotRequired.
  4. Required.
View Answer/Explanation:
d
Explanation:

Question No: 9 of 9
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse. You have decided to make use of the Environment Variable package configuration as part of your solution. Which of the following is TRUE with regards to the Environment Variable package configuration? 
Options:
  1. It stores the property path inside the package and the value outside the package
  2. It stores both the property path and the value outside the package
  3. It is used to fetch a value from a variable in a calling package
  4. It is the most commonly used configuration type
View Answer/Explanation:
a
Explanation:

  1