Question 1

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

Accepted Answer

A)  Dynamic MQ Series target 
B)  MS target 
C)  Relational target 
D)  XML target 
A)  Dynamic MQ Series target 
B)  MS target 
C)  Relational target 
D)  XML target B

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

Which statement on workflows is correct?

Accepted Answer

A)  In a default configuration, a workflow must contain at least one session task 
B)  A workflow can contain multiple start points 
C)  In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions 
D)  Another workflow cannot be executed from within a workflow 
A)  In a default configuration, a workflow must contain at least one session task 
B)  A workflow can contain multiple start points 
C)  In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions 
D)  Another workflow cannot be executed from within a workflow

Question 5

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

Accepted Answer

A)  Lookup, stored procedure, external procedure 
B)  Lookup, stored procedure, Java 
C)  Java, lookup, transaction control 
D)  Transaction control, Java, lookup 
A)  Lookup, stored procedure, external procedure 
B)  Lookup, stored procedure, Java 
C)  Java, lookup, transaction control 
D)  Transaction control, Java, lookup

Question 6

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

Accepted Answer

A)  Infasetup 
B)  infacmd 
C)  pmcmd 
D)  pmrep 
A)  Infasetup 
B)  infacmd 
C)  pmcmd 
D)  pmrep

Question 7

Which is the correct priority of assigning a mapping variable?

Accepted Answer

A)  Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value 
B)  Session parameter file, workflow parameter file, repository value, declared initial value 
C)  Repository value, workflow parameter file, pre-session assignment, session parameter file, default value 
D)  Repository value, declared initial value, default value 
A)  Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value 
B)  Session parameter file, workflow parameter file, repository value, declared initial value 
C)  Repository value, workflow parameter file, pre-session assignment, session parameter file, default value 
D)  Repository value, declared initial value, default value

Question 8

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

Accepted Answer

A)  Pass-through 
B)  Hash auto-keys 
C)  Not a valid partition points 
D)  Based on the transformation scope 
A)  Pass-through 
B)  Hash auto-keys 
C)  Not a valid partition points 
D)  Based on the transformation scope

Question 9

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?

Accepted Answer

A)  STATE 
B)  'CA' 
C)  NULL 
D)  Value of the PREVI0US_STATE port is based upon its declared default value 
A)  STATE 
B)  'CA' 
C)  NULL 
D)  Value of the PREVI0US_STATE port is based upon its declared default value

Question 10

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Accepted Answer

A)  Pipeline A 
B)  Pipeline B 
C)  Both Pipelines should be cached for performance reasons 
D)  Pipeline B if and only if Pipeline A is sorted 
A)  Pipeline A 
B)  Pipeline B 
C)  Both Pipelines should be cached for performance reasons 
D)  Pipeline B if and only if Pipeline A is sorted

Question 11

Given the picture shown below:   Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question. The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST :

Accepted Answer

A)  Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST 
B)  Describes an INNER JOIN between PRODUCT AND PRODUCT_COST 
C)  Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST 
D)  Can be created within Informatica PowerCenter 
A)  Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST 
B)  Describes an INNER JOIN between PRODUCT AND PRODUCT_COST 
C)  Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST 
D)  Can be created within Informatica PowerCenter

Question 12

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

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 13

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

Accepted Answer

A) True 
 B)False

Question 14

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

Accepted Answer

A)  Character day of week, character day of month, and character day of year respectively 
B)  Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively 
C)  Each produces numerical day of week 
D)  Numerical day of week, day of month, and day of year respectively 
A)  Character day of week, character day of month, and character day of year respectively 
B)  Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively 
C)  Each produces numerical day of week 
D)  Numerical day of week, day of month, and day of year respectively

Question 15

Which of following statements is valid for Dynamic lookups?

Accepted Answer

A)  Dynamic caching cannot be enabled on a lookup that returns multiple rows per search 
B)  A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert 
C)  A dynamic lookup must be cached and persistent 
D)  It is possible to update and delete records in a dynamic lookup 
A)  Dynamic caching cannot be enabled on a lookup that returns multiple rows per search 
B)  A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert 
C)  A dynamic lookup must be cached and persistent 
D)  It is possible to update and delete records in a dynamic lookup

Question 16

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

Accepted Answer

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

Question 17

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')

Accepted Answer

A)  CHOOSE 
B)  REPLACECHR 
C)  REG_REPLACE 
D)  INSTR 
A)  CHOOSE 
B)  REPLACECHR 
C)  REG_REPLACE 
D)  INSTR

Question 18

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

Accepted Answer

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

Question 19

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

Accepted Answer

A)  The transformation's name, one of its port's default values, the tracing level or a Metadata Extension 
B)  The transformation's name or the tracing level 
C)  The transformation's name, one of its port's default values or the tracing level 
D)  The transformation's name is the only attribute that can be changed 
A)  The transformation's name, one of its port's default values, the tracing level or a Metadata Extension 
B)  The transformation's name or the tracing level 
C)  The transformation's name, one of its port's default values or the tracing level 
D)  The transformation's name is the only attribute that can be changed

Question 20

The word FALSE is a valid Filter transformation condition?

Accepted Answer

A) True 
 B)False

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

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

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

Which statement on workflows is correct?

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

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

Which is the correct priority of assigning a mapping variable?

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

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?

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Given the picture shown below: Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question. The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST :

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

Which of following statements is valid for Dynamic lookups?

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

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')

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

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

The word FALSE is a valid Filter transformation condition?

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x Administrator Specialist

Filters

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

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

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

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

Which statement on workflows is correct?

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

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

Which is the correct priority of assigning a mapping variable?

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

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?

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Given the picture shown below: Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question. The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST :

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

Which of following statements is valid for Dynamic lookups?

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

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')

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

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

The word FALSE is a valid Filter transformation condition?

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x Administrator Specialist

Filters