PR000041 Online Practice Questions and Answers

Which statement on workflows is correct?

A. In a default configuration, a workflow must contain at least one session task

B. A workflow can contain multiple start points

C. In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

D. Another workflow cannot be executed from within a workflow

Which of following statements is valid for Dynamic lookups?

A. Dynamic caching cannot be enabled on a lookup that returns multiple rows per search

B. A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

C. A dynamic lookup must be cached and persistent

D. It is possible to update and delete records in a dynamic lookup

Which is the correct priority of assigning a mapping variable?

A. Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

B. Session parameter file, workflow parameter file, repository value, declared initial value

C. Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

D. Repository value, declared initial value, default value

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 statements is correct on workflow events?

A. A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping

B. A user-defined event can be created a-d raised in one workflow and then used In another

C. A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.

D. A user-defined event can be created in either the Event Wait or Event Raise task

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

A. Pass-through

B. Hash auto-keys

C. Not a valid partition points

D. Based on the transformation scope

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

A. Filter, Joiner, Rank

B. Union, Filter, Aggregator

C. Rank, Lookup, Aggregator

D. Joiner, Rank, Sorter

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

A. True

B. False

What is the first column of the bad file?

A. Reject reason

B. Column Indicator

C. Overflow Indicator

D. Row Indicator

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

A. Dynamic MQ Series target

B. MS target

C. Relational target

D. XML target