Download PowerCenter Data Integration 9.x:Developer Specialist.PR000041.PassLeader.2019-03-03.70q.tqb

Vendor:	Informatica
Exam Code:	PR000041
Exam Name:	PowerCenter Data Integration 9.x:Developer Specialist
Date:	Mar 03, 2019
File Size:	754 KB

Download Exam

How to open TQB files?

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Demo Questions

Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

XML
XSD
DTD
DSDL

Correct answer: ABC

Which of these statements on worklets is correct?

Worklets can be nested
A worklet must be a reusable object
A worklet can be executed separately
A worklet does not have to contain a Start task

Correct answer: A

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly
Records that are tagged for rejection are dropped and not projected downstream to the next transformation
The Forward Rejected Rows attribute cannot be cleared after the transformation is created
The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Correct answer: B

An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

From an expression
As a Post-Session SQL command
As a Pre-Session SQL command
As the only object In the mapping

Correct answer: ABC

Which of the following Is NOT true of Aggregate functions?

You can place an aggregate function in a variable port
You can add a filter condition to calculate values for specific rows In the selected ports
You can use operators to perform arithmetic within the function
You can calculate a single value for all rows in a group

Correct answer: A

Which statement on workflows is correct?

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

Correct answer: C

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

A persistent cache is stored on disk, and must be named to make it useable in multiple mappings
persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually
When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails
A persistent cache can only be used by one mapping

Correct answer: A

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

DELETE
GET
POST
PUT

Correct answer: BC

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

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?