exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 1 question 39 discussion

Actual exam question from Microsoft's 70-463
Question #: 39
Topic #: 1
[All 70-463 Questions]

DRAG DROP -
You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be located for further processing.
You need to design a solution so that the file path can be easily configured with the least administrative and development effort.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References: http://msdn.microsoft.com/en-us/library/hh479588.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
brenns1
4 years, 5 months ago
Disagree with the previous as they ask for the solution easiest and simplest to configure which they will always push as being environment variables through a project deployment. Just by the steps listed in alternative shows is no easiest.
upvoted 1 times
...
LuckyKatt
5 years, 6 months ago
Given that the question specifies that A executes B, it seems more likely that MS was looking or the Parent Package Variable solution. So 1. Create SSIS project containing A and B 2. Add package parameter FilePath 3. Add config file in A to set FilePath 4. Add Parent Package Variable in B to set FilePath
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...