Download PowerCenter Data Integration 9.x:Developer Specialist.PR000041.Pass4sures.2018-09-20.42q.vcex

Vendor: Informatica
Exam Code: PR000041
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
Date: Sep 20, 2018
File Size: 411 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
ProfExam Discount

Demo Questions

Question 1
Which of the following is a reusable task available in workflow manager?
  1. Decision
  2. Assignment
  3. Control
  4. Command
Correct answer: B
Question 2
In which of the following selections are all of the transformations active?
  1. Expression, Router, Joiner
  2. Update Strategy, Expression, Aggregator
  3. Stored Procedure, Joiner, Router
  4. Router, Update Strategy, Joiner
Correct answer: D
Question 3
Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)
  1. An unconnected lookup can return multiple rows while a connected lookup may return only one
  2. Both connected and unconnected lookups can return multiple rows
  3. An unconnected lookup may return only one value while a connected lookup may return multiple rows
  4. Both connected and unconnected lookups can return only one row
Correct answer: C
Question 4
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
  1. Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST
  2. Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
  3. Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST
  4. Can be created within Informatica PowerCenter
Correct answer: BD
Question 5
Which of the following statements is correct on workflow events?
  1. 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
  2. A user-defined event can be created a-d raised in one workflow and then used In another
  3. 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.
  4. A user-defined event can be created in either the Event Wait or Event Raise task
Correct answer: C
Question 6
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?
  1. Pipeline A
  2. Pipeline B
  3. Both Pipelines should be cached for performance reasons
  4. Pipeline B if and only if Pipeline A is sorted
Correct answer: A
Question 7
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?
  1. Pass-through
  2. Hash auto-keys
  3. Not a valid partition points
  4. Based on the transformation scope
Correct answer: B
Question 8
When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)
  1. Filter, Joiner, Rank
  2. Union, Filter, Aggregator
  3. Rank, Lookup, Aggregator
  4. Joiner, Rank, Sorter
Correct answer: D
Question 9
Given a Union transformation with 2 input groups, which statement is correct and true?
  1. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
  2. Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.
  3. When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
  4. The port names in each input group can be named the same.
Correct answer: A
Question 10
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)
  1. Read permissions on the two folders
  2. Read permissions on the two folders as well as have both folders opened
  3. Full access (Read, Write and Execute permissions) on both folders
  4. Mappings cannot be compared across folders using PowerCenter Designer
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!