Question 1

The word FALSE is a valid Filter transformation condition?

ATrue

BFalse

Answer : B

Question 2

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

AROUND

BTRUNC

CINSTR

DCONCAT

Answer : A

Question 3

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

ACharacter day of week, character day of month, and character day of year respectively

BDay of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

CEach produces numerical day of week

DNumerical day of week, day of month, and day of year respectively

Answer : D

Question 4

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

A5 fields are in the index cache and 3 are in the data cache

B3 fields are in the index cache and 2 fields are in the data cache

C2 fields are in the index cache and 3 fields are in the data cache

D2 fields are in the index and 5 fields are in the data cache

Answer : A

Question 5

Which of the following techniques could be used to filter data read from a flat file source?

ACreate a valid condition in the Filter attribute of the flat file's Source Qualifier

BPlace a Filter transformation directly after the flat file's Source Qualifier

CAn Expression transformation with an output port's expression defined to filter records

DAn Expression transformation with all of the output port's default values set to blank