70-463 · Question #185
70-463 Question #185: Real Exam Question with Answer & Explanation
The correct answer is A: an Expression task. Note: The stated correct answer is A (Expression task), but technically an Expression task evaluates SSIS expressions (e.g., @[System::StartTime]) and cannot query an external database. The textbook correct answer for reading a value from a database control table and storing it i
Question
Options
- Aan Expression task
- Ban Execute SQL task
- Ca Script component
- Da Script task
Explanation
Note: The stated correct answer is A (Expression task), but technically an Expression task evaluates SSIS expressions (e.g., @[System::StartTime]) and cannot query an external database. The textbook correct answer for reading a value from a database control table and storing it in a variable with minimal effort is B - the Execute SQL task. The Execute SQL task connects to Azure SQL Database, runs a SELECT against the control table, and maps the result directly to the CurrentDate package variable via its Result Set mapping - no custom code required. A Script task (D) could do it but requires writing .NET code, meaning more effort. A Script component (C) is a data flow component and is not appropriate for this control-flow variable assignment. If the exam key says A, it likely contains an error; B is the operationally correct answer for this scenario.
Community Discussion
No community discussion yet for this question.