nerdexam
Microsoft

70-448 · Question #316

70-448 Question #316: Real Exam Question with Answer & Explanation

Sign in or unlock 70-448 to reveal the answer and full explanation for question #316. The question stem and answer options stay visible for context.

Question

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. You make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at the following SQL Server 2008 table. The package loads the data extracted from a text file to this table. Now you receive an order from your company CIO, the package has to be updated to extract data from multiple text files of the same directory. In order to achieve this goal, what should you do? (Choose more than one)

Exhibit

70-448 question #316 exhibit

Options

  • AAn expression should be added to the Flat File connection manager
  • BA variable should be added to the package
  • CA For Loop container should be added to the package
  • DA variable should be added to the data flow task
  • EAd Foreach Loop container should be added to the package
  • FAn expression should be added to the Flat File Source component

Unlock 70-448 to see the answer

You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-448 Practice