Microsoft
70-463 · Question #29
70-463 Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT statement. The task has the following requirements: - The INSERT statement must use the value of a string package variable. - The variable name is StringVar. - The Execute SQL task must use an OLE DB Connection Manager. In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter. You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?
Options
- AINSERT INTO dbo.Table (variablevalue) VALUES ($StringVar)
- BINSERT INTO dbo.Table (variablevalue) VALUES (0)
- CINSERT INTO dbo.Table (variablevalue) VALUES (@0)
- DINSERT INTO dbo.Table (variablevalue) VALUES (?)
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.