Online PR000041 Questions Video

Page: 2 / 2

Question 8

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

Options:

XML

XSD

DTD

DSDL

Question 9

Which of these statements is correct concerning a Lookup transformation's persistent cache?

Options:

A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

A persistent cache can only be used by one mapping

Question 10

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

Options:

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

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.

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

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

Page: 2 / 2

Online PR000041 Questions Video,

Exam Code: PR000041

Exam Name: PowerCenter Data Integration 9.x:Developer Specialist

Last Update: Dec 22, 2024

Questions: 70