PrepAway - Latest Free Exam Questions & Answers

Which of the following is TRUE with regards to Expression Task?

You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
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?

PrepAway - Latest Free Exam Questions & Answers

A.
It creates and evaluates expressions that set variable values at runtime.

B.
It provides code to perform functions that are not available in the built-in tasks and
transformations that SQL Server Integration Services provides.

C.
It runs an application or batch file as part of a SQL Server Integration Services package
workflow.

D.
It allows you to run SQL statements during package execution.

Explanation:


Leave a Reply