Microsoft
70-463 · Question #218
70-463 Question #218: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #218. The question stem and answer options stay visible for context.
Question
In your SSIS solution, you need to load a large set of rows into the database as quickly as possible. The rows are stored in a delimited text file, and only one source column needs its data type converted from String (used by the source column) to Decimal (used by the destination column). What control flow task would be most suitable for this operation?
Options
- AThe File System task would be perfect in this case, because it can read data from files and
- BThe Bulk Insert task would be the most appropriate, because it is the quickest and can
- CThe data flow task would have to be used, because the data needs to be transformed before
- DNo single control flow task can be used for this operation, because the data needs to be
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 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.