An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

A. Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly

B. Records that are tagged for rejection are dropped and not projected downstream to the next transformation

C. The Forward Rejected Rows attribute cannot be cleared after the transformation is created

D. The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Which of these statements is correct concerning a Lookup transformation's persistent cache?

A. A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

B. persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

C. When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

D. A persistent cache can only be used by one mapping

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

A. lnput

B. Output

C. Variable

D. Return

What is a pipeline lookup transformation?

A. A lookup created using a pipeline which contains a target

B. A lookup cache split over pipelines of a partitioned mapping

C. A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

D. A pipeline lookup does not exist

Which of the following is a reusable task available in workflow manager?

A. Decision

B. Assignment

C. Control

D. Command

Referring to the SQL Transformation: which statements is correct and true.

A. The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

B. The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next

C. In PowerCenter 9 the SQL transformation, in query mode, can only be active

D. When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)

Please choose one of the following. In a static, non-multi-row lookup,

A. lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

B. If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

C. If the lookup finds two records that match the search key, it will return two records

D. None of the above

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than

1.

A. True

B. False

Given the picture shown below: How many columns would be selected from the database using PowerCenter's generated sql statement?

A. 2 - Due to the line on the left hand side of the picture

B. 13 - Based on all of the links entering the Source Qualifier

C. 3 - Based on the all of the links between the Source Qualifier and the next transformation

D. Unknown - We need to know how many columns the target has

Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)

· Workflows > Start Workflow A. AII objects displayed will be executed

B. The Start task only will be executed

C. The Start task and the link will execute, while the session task will wait to execute

D. The Start task and link only will be execute