Certbus > Informatica > Developer Specialist > PR000041 > PR000041 Online Practice Questions and Answers

PR000041 Online Practice Questions and Answers

Questions 4

Which of the following Is NOT true of Aggregate functions?

A. You can place an aggregate function in a variable port

B. You can add a filter condition to calculate values for specific rows In the selected ports

C. You can use operators to perform arithmetic within the function

D. You can calculate a single value for all rows in a group

Browse 70 Q&As
Questions 5

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

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

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

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

D. A persistent cache can only be used by one mapping

Browse 70 Q&As
Questions 6

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

A. DELETE

B. GET

C. POST

D. PUT

Browse 70 Q&As
Questions 7

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

A. Lookup, stored procedure, external procedure

B. Lookup, stored procedure, Java

C. Java, lookup, transaction control

D. Transaction control, Java, lookup

Browse 70 Q&As
Questions 8

What is the first column of the bad file?

A. Reject reason

B. Column Indicator

C. Overflow Indicator

D. Row Indicator

Browse 70 Q&As
Questions 9

Please choose one of the following. In a static, non-multi-row lookup,

A. lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

B. If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

C. If the lookup finds two records that match the search key, it will return two records

D. None of the above

Browse 70 Q&As
Questions 10

By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

A. Check the Fail Parent if this task fails option box on the session task

B. Use a Control Task with a Control Option setting of Fail Me

C. Use an assignment task to call the ERROR() function

D. Use a command task to set the value of $RC to a negative number

Browse 70 Q&As
Questions 11

Refering to the Lookup transformation, which statement is correct and true?

A. The lookup condition defines how much memory each of the two caches will consume

B. The lookup condition defines the fields that are used in the search of the data

C. The lookup condition is limited to only the equal operator

D. The lookup condition is designated in the ports tab interface via the "L" check box

Browse 70 Q&As
Questions 12

Referring to the Sequence Generator transformation, which statement is correct and true?

A. The NextVal column produces the next number in the sequence

B. The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

C. The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

D. The Sequence Generator contains a single input port that represents the initial starting point of the sequence

Browse 70 Q&As
Questions 13

Which of the following statements regarding mapplets are correct and true?

A. A mapplet can contain a target definition

B. A mapplet can contain a source definition as well as a source qualifier

C. Every mapplet must have at least 1 Input transformation as well as 1 Output transformation

D. A mapplet can contain a Normalizer transformation

Browse 70 Q&As
Questions 14

The Informatics Date/Time datatype supports values up to which level? (choose one)

A. Picosecond

B. Microsecor|d

C. Nanosecond

D. Millisecond

Browse 70 Q&As
Questions 15

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

Browse 70 Q&As
Questions 16

Referring to a lookup transformation: Which of the following statements are true and correct?

A. The caching of a flat file is optional if the data in the flat file is sorted

B. The lookup index cache file contains a searchable index of the records based on the lookup condition

C. When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

D. The data cache contains all of the fields in the lookup transformation

Browse 70 Q&As
Questions 17

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

A. ROUND

B. TRUNC

C. INSTR

D. CONCAT

Browse 70 Q&As
Questions 18

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

Browse 70 Q&As
Exam Code: PR000041
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
Last Update: Mar 22, 2024
Questions: 70 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99