Microsoft
70-463 · Question #11
70-463 Question #11: Real Exam Question with Answer & Explanation
The correct answer is A: Expression task. This question tests knowledge of the SSIS Expression task, which is the purpose-built, lowest-effort way to evaluate an expression and assign its result to a variable at runtime.
Question
You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. What should you use?
Options
- AExpression task
- BScript task
- CExecute SQL task
- DExecute Process task
- ETerm Extraction transformation
Explanation
This question tests knowledge of the SSIS Expression task, which is the purpose-built, lowest-effort way to evaluate an expression and assign its result to a variable at runtime.
Common mistakes.
- B. A Script task can change variables but requires writing and maintaining custom VB.NET or C# code, which is significantly more development effort than an Expression task.
- C. An Execute SQL task can store query results into variables but requires a database connection, a SQL statement, and result set mapping configuration, adding unnecessary complexity.
- D. An Execute Process task launches an external executable and is not designed for variable manipulation within the SSIS runtime.
- E. Term Extraction is a data flow transformation that identifies noun phrases from text columns; it has no capability to set package variable values.
Concept tested. SSIS Expression task for runtime variable assignment
Reference. https://learn.microsoft.com/en-us/sql/integration-services/control-flow/expression-task
Community Discussion
No community discussion yet for this question.