Informatica PR000041 Online Practice Questions and Exam Preparation

Informatica PR000041 Online Questions & Answers

• Question 31:

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

  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
  B. The transformation's name or the tracing level

• Question 32:

  From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

  A. Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox
  B. Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping
  C. Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down
  D. No
  C. Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

• Question 33:

  Which is the correct priority of assigning a mapping variable?

  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

• Question 34:

  Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid) ?Workflows>; Start Workflow

  

  A. AII objects displayed will be executed
  B. The Start task only will be executed
  C. The Start task and the link will execute, while the session task will wait to execute
  D. The Start task and link only will be execute
  D. The Start task and link only will be execute

• Question 35:

  Which of following statements is valid for Dynamic lookups?

  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

• Question 36:

  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
  A. When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

• Question 37:

  Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

  A. lnput
  B. Output
  C. Variable
  D. Return
  A. lnput
  B. Output
  D. Return

• Question 38:

  Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

  

  Identify all of the true and correct statements listed below. Choose 2 answers

  A. This picture depicts a join that will be processed within the Informatica PowerCenter engine
  B. This picture depicts a join that will be processed in a database
  C. This picture depicts a SQL UNION operation
  D. This picture depicts an Informatica Homogeneous Join
  B. This picture depicts a join that will be processed in a database
  C. This picture depicts a SQL UNION operation

• Question 39:

  Given the picture shown below: How many columns would be selected from the database using PowerCenter's generated sql statement?

  

  A. 2 - Due to the line on the left hand side of the picture
  B. 13 - Based on all of the links entering the Source Qualifier
  C. 3 - Based on the all of the links between the Source Qualifier and the next transformation
  D. Unknown - We need to know how many columns the target has
  C. 3 - Based on the all of the links between the Source Qualifier and the next transformation

• Question 40:

  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?

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