New Year Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Get Certified: Proven Methods to Pass the Informatica PR000041 Exam

Questions 11

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

Options:
A.

1

B.

2

C.

3

D.

4

Informatica PR000041 Premium Access
Questions 12

Which statement on workflows is correct?

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

Questions 13

The Informatics Date/Time datatype supports values up to which level? (choose one)

Options:
A.

Picosecond

B.

Microsecor|d

C.

Nanosecond

D.

Millisecond

Questions 14

Which of the following is true about database connections?

Options:
A.

Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS

B.

PowerCenter connections may be created In either the Administrator or the Workflow Manager

C.

MRS connections may be created in either the Workflow Manager or the Administrator

D.

Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories

Questions 15

Referring to the SQL Transformation: which statements is correct and true.

Options:
A.

The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

B.

The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next

C.

In PowerCenter 9 the SQL transformation, in query mode, can only be active

D.

When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)

Questions 16

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

Options:
A.

From an expression

B.

As a Post-Session SQL command

C.

As a Pre-Session SQL command

D.

As the only object In the mapping

Questions 17

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

Options:
A.

True

B.

False

Questions 18

Of the statements below, which best describes the underlying process taken when a user connects to a PowerCenter Repository Service for the first time? For the puposes of this question, the PowerCenter Developer is the only PowerCenter client application running, there are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node. The PowerCenter Repository Service is running on the worker node.

Options:
A.

The user connects directly and immediately to the Repository Service

B.

The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service

C.

The user connects to the service manager of the worker node that is running the Repository Service, is then authenticated, authorized, and connected to the PowerCenter Repository Service

D.

The user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service

Questions 19

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

Options:
A.

lnput

B.

Output

C.

Variable

D.

Return

Questions 20

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

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

Exam Code: PR000041
Certification Provider: Informatica
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
Last Update: Jan 20, 2025
Questions: 70

Informatica Related Exams

Data-Quality-10-Developer-Specialist - Data Quality 10: Developer Specialist Exam
Informatica Free Access
Get Informatica Full Access

Informatica Free Exams
Informatica Free Exams
Examstrack provides free Informatica exam prep materials and practice tests to support your Informatica certification goals.