A.They are added to the overflow file

B.They are deleted from the target

C.They are flagged for later deletion

D.They are filtered by the transform

A.By using the interactive debugger

B.By setting the Audit Data On job execution trace option

C.By adding audit points in the dataflow

D.By setting the SQL Transforms on job execution trace option

A.Ordering

B.Custom function

C.Join

D.XML function

E.Distinct

A.To output all rows that match the case statement

B.to output all rows that do match exactly one case expression

C.To output all rows to the default path regardless if the they match the case expressions.

D.To output all rows that do not match any case expression to the default path

A.View and modify the SQL and adjust the dataflow to maximize push-down operations.

B.View and modify the overall optimization plan of a data services engine

C.View and modify the SQL to improve performance

D.View and modify the database execution plan within the Data Services Designer