PR000041 Online Practice Questions and Answers

Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

A. XML

B. XSD

C. DTD

D. DSDL

An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

A. From an expression

B. As a Post-Session SQL command

C. As a Pre-Session SQL command

D. As the only object In the mapping

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

A. STATE

B. 'CA'

C. NULL

D. Value of the PREVI0US_STATE port is based upon its declared default value

Which command line tool would you use to execute a workflow?

A. infasetup

B. infacmd

C. pmcmd

D. pmrep

When would a Lookup transformation be classified as active?

A. When the setting for lookup policy on multiple match is Use Any Value

B. A lookup cannot be an active transformation

C. When the lookup is configured to return multiple rows

D. A lookup is always active

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

A. Infasetup

B. infacmd

C. pmcmd

D. pmrep

When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?

A. The data from the detail pipeline Is used to build the cache files used In the join process

B. The data from the master pipeline is used to build the cache files used in the join process

C. The cache files are built according to a sql override found on the Joiner Properties tab

D. The Joiner transformation uses the database to build the join result

Referring to the Java transformation: select the statement below which is correct and true.

A. The Integration Service starts a JVM that executes the byte code to process data

B. PowerCenter requires an Eclipse Java Development Environment for the Java transformation

C. No Third Party Java API's are supported in the Java transformation

D. The Java transformation icon in PowerCenter Designer resembles a coffee bean

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

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

A. 5 fields are in the index cache and 3 are in the data cache

B. 3 fields are in the index cache and 2 fields are in the data cache

C. 2 fields are in the index cache and 3 fields are in the data cache

D. 2 fields are in the index and 5 fields are in the data cache