File Info
| Exam | PowerCenter Data Integration 9.x:Developer Specialist |
| Number | PR000041 |
| File Name | Informatica.PR000041.TestInside.2018-10-24.36q.vcex |
| Size | 248 KB |
| Posted | Oct 24, 2018 |
| Download | Informatica.PR000041.TestInside.2018-10-24.36q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers
- DELETE
- GET
- POST
- PUT
Correct answer: BC
Question 2
Which of following statements is valid for Dynamic lookups?
- Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
- 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
- A dynamic lookup must be cached and persistent
- It is possible to update and delete records in a dynamic lookup
Correct answer: A
Explanation:
Question 3
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?
- STATE
- 'CA'
- NULL
- Value of the PREVI0US_STATE port is based upon its declared default value
Correct answer: B
Question 4
What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?
functionname{1, COMPANY, 'i' , 'I')
- CHOOSE
- REPLACECHR
- REG_REPLACE
- INSTR
Correct answer: B
Question 5
Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers
- lnput
- Output
- Variable
- Return
Correct answer: ABD
Question 6
What is a pipeline lookup transformation?
- A lookup created using a pipeline which contains a target
- A lookup cache split over pipelines of a partitioned mapping
- A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
- A pipeline lookup does not exist
Correct answer: C
Question 7
Which of the following is a reusable task available in workflow manager?
- Decision
- Assignment
- Control
- Command
Correct answer: B
Question 8
In which of the following selections are all of the transformations active?
- Expression, Router, Joiner
- Update Strategy, Expression, Aggregator
- Stored Procedure, Joiner, Router
- Router, Update Strategy, Joiner
Correct answer: D
Question 9
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 : Choose 2 answers
- Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST
- Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
- Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST
- Can be created within Informatica PowerCenter
Correct answer: BD
Question 10
Which of the following statements is correct on workflow events?
- A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping
- A user-defined event can be created a-d raised in one workflow and then used In another
- A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.
- A user-defined event can be created in either the Event Wait or Event Raise task
Correct answer: C
