nerdexam
Microsoft

70-463 · Question #113

You are in the process of creating a SQL Server Integration Services (SSIS) package. You have decided to make use of Expression Task. Which of the following is TRUE with regards to Expression Task?

The correct answer is A. It creates and evaluates expressions that set variable values at runtime. The SSIS Expression Task evaluates SSIS expressions and assigns the resulting values to package variables at runtime, introduced in SQL Server 2012.

Configure and deploy SSIS solutions

Question

You are in the process of creating a SQL Server Integration Services (SSIS) package. You have decided to make use of Expression Task. Which of the following is TRUE with regards to Expression Task?

Options

  • AIt creates and evaluates expressions that set variable values at runtime.
  • BIt provides code to perform functions that are not available in the built-in tasks and
  • CIt runs an application or batch file as part of a SQL Server Integration Services package
  • DIt allows you to run SQL statements during package execution.

How the community answered

(69 responses)
  • A
    94% (65)
  • B
    1% (1)
  • C
    3% (2)
  • D
    1% (1)

Why each option

The SSIS Expression Task evaluates SSIS expressions and assigns the resulting values to package variables at runtime, introduced in SQL Server 2012.

AIt creates and evaluates expressions that set variable values at runtime.Correct

The Expression Task was introduced in SQL Server 2012 Integration Services specifically to create and evaluate expressions that set variable values at runtime using the SSIS expression language. It provides a dedicated, lightweight control flow task for updating variable values without requiring the overhead of a Script Task.

BIt provides code to perform functions that are not available in the built-in tasks and

Providing custom code for functions not available in built-in tasks describes the Script Task, which executes VB.NET or C# code.

CIt runs an application or batch file as part of a SQL Server Integration Services package

Running an application or batch file as part of an SSIS package describes the Execute Process Task, not the Expression Task.

DIt allows you to run SQL statements during package execution.

Running SQL statements during package execution describes the Execute SQL Task, which connects to a relational database and executes queries or stored procedures.

Concept tested: SSIS Expression Task purpose and variable assignment at runtime

Source: https://learn.microsoft.com/en-us/sql/integration-services/control-flow/expression-task

Topics

#Expression Task#variable values#runtime expressions#control flow

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice