Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

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

A.

True

B.

False

Full Access
Question # 5

When would a Lookup transformation be classified as active?

A.

When the setting for lookup policy on multiple match is Use Any Value

B.

A lookup cannot be an active transformation

C.

When the lookup is configured to return multiple rows

D.

A lookup is always active

Full Access
Question # 6

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

Full Access
Question # 7

In which of the following selections are all of the transformations active?

A.

Expression, Router, Joiner

B.

Update Strategy, Expression, Aggregator

C.

Stored Procedure, Joiner, Router

D.

Router, Update Strategy, Joiner

Full Access
Question # 8

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?

A.

Pipeline A

B.

Pipeline B

C.

Both Pipelines should be cached for performance reasons

D.

Pipeline B if and only if Pipeline A is sorted

Full Access
Question # 9

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

Full Access
Question # 10

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

Full Access