Exam 70-463 topic 1 question 32 discussion

Actual exam question from Microsoft's 70-463

Question #: 32
Topic #: 1

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure.
The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model.
Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package.
You need to configure the package to accept the folder path from each job.
Which package configuration should you use?

A. .dtsConfig file
B. Registry Entry
C. Environment Variable
D. Parent Package Variable
E. XML Configuration File

Show Suggested Answer

Suggested Answer: C 🗳️
References: http://msdn.microsoft.com/en-us/library/ms345179.aspx http://msdn.microsoft.com/en-us/library/ms141708.aspx http://msdn.microsoft.com/en-us/library/hh213214.aspx http://msdn.microsoft.com/en-us/library/hh213296.aspx http://msdn.microsoft.com/en-us/library/hh213293.aspx

by LuckyKatt at Dec. 29, 2019, 2:50 a.m.

Comments

Submit Cancel

LuckyKatt

5 years, 7 months ago

A variable that changes from execution to execution doesn't seem like it should be environment, more like a project or package variable. But since that isn't an option, Environment variable does seem like the best option of the ones listed.

upvoted 1 times

...