Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

Which of the following Is NOT true of Aggregate functions?

AYou can place an aggregate function in a variable port

BYou can add a filter condition to calculate values for specific rows In the selected ports

CYou can use operators to perform arithmetic within the function

DYou can calculate a single value for all rows in a group

Answer : A

Question 2

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)

ARead permissions on the two folders

BRead permissions on the two folders as well as have both folders opened

CFull access (Read, Write and Execute permissions) on both folders

DMappings cannot be compared across folders using PowerCenter Designer

Answer : B

Question 3

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

APicosecond

BMicrosecor|d

CNanosecond

DMillisecond

Answer : C

Question 4

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

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

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

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

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

Answer : A

Question 5

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

AOption A

BOption B

COption C

DOption D

Answer : A, C

Question 6

A workflow has a session task. Both workflow and session each have been assigned a different parameter file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"

Workflow Parameter file:

[Global] $$ParameterValue=l

[Session] $$ParameterValue=2

Session Parameter file:

[Global] $$ParameterValue=3

[Session] $$ParameterValue=4

Answer : A

Question 7

Referring to the SQL Transformation: which statements is correct and true.

AThe SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

BThe SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next

CIn PowerCenter 9 the SQL transformation, in query mode, can only be active

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

Answer : C

Informatica PowerCenter Data Integration 9.x:Developer Specialist PR000041 ICP Exam Practice Test