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

How does a single joiner transformation join data?

A. From 2 pipeline inputs

B. From 3 pipeline inputs

C. From n number of pipeline inputs assuming you have purchased the N-Joiner Option

D. none of the above

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 (!)

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

A. Expression and Update Strategy

B. Update Strategy

C. Update Strategy and Lookup

D. Expression, Aggregator, and Update Strategy

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

A. When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

B. When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.

C. If the distinct check box is not checked, the sorter will produce one record per unique key

D. The Sorter transformation will utilize database indexes from the source database to perform the sort

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

Which statement is correct regarding User-Defined Functions (UDF)?

A. A UDF name can contain letters, numbers and underscores

B. Can be used in mappings and transformations however not in mapplets

C. Can be reused from a shared folder as shortcut

D. Can contain Java code snippets

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

A. If a transformation's Active property is cleared or not enabled, the transformation becomes passive

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 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

Which of the following techniques could be used to filter data read from a flat file source?

A. Create a valid condition in the Filter attribute of the flat file's Source Qualifier

B. Place a Filter transformation directly after the flat file's Source Qualifier

C. An Expression transformation with an output port's expression defined to filter records

D. An Expression transformation with all of the output port's default values set to blank