Microsoft
70-448 · Question #4
70-448 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do?
Options
- AConfigure the FTP tasks to support transactions.
- BConfigure the Execute SQL tasks to support transactions.
- CMove all the FTP tasks to a sequence container.
- DConfigure the package to use a checkpoint.
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.