PR000041 Online Practice Questions and Answers

The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers

A. DELETE

B. GET

C. POST

D. PUT

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 is a reusable task available in workflow manager?

A. Decision

B. Assignment

C. Control

D. Command

Two pipelines (A and B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

A. Pipeline A

B. Pipeline B

C. Both Pipelines should be cached for performance reasons

D. Pipeline B if and only if Pipeline A is sorted

Given a Union transformation with 2 input groups, which statement is correct and true?

A. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

B. Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

C. When merging the 2 groups of data together, the Union transformation will remove duplicate rows.

D. The port names in each input group can be named the same.

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

Which command line tool would you use to import a workflow into a repository?

A. Infasetup

B. infacmd

C. pmcmd

D. pmrep

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

A. A transformation is active if It rearranges the order of the rows in the pipeline

B. A transformation is active if it does not change the number of rows in the pipeline

C. Transformations can be active and passive at the same time

D. A passive transformation will not change the number of rows in the pipeline

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

A. Option A

B. Option B

C. Option C

D. Option D