Online Access Free PR000041 Exam Questions

Which of the following is true about database connections?

• A.MRS connections may be created in either the Workflow Manager or the Administrator
• B.Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
• C.Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories
• D.PowerCenter connections may be created In either the Administrator or the Workflow Manager

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

• A.Infasetup
• B.infacmd
• C.pmrep
• D.pmcmd

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

• A.True
• B.False

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

Identify all of the true and correct statements listed below. Choose 2 answers

• A.This picture depicts an Informatica Homogeneous Join
• B.This picture depicts a SQL UNION operation
• C.This picture depicts a join that will be processed in a database
• D.This picture depicts a join that will be processed within the Informatica PowerCenter engine

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.The Start task and link only will be execute
• B.The Start task only will be executed
• C.AII objects displayed will be executed
• D.The Start task and the link will execute, while the session task will wait to execute