최신 IBM Information Management P2090-046 무료샘플문제:
1. The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?
A) NULL is written to the target stage variable.
B) The job aborts.
C) The input row is either dropped or rejected depending on whether the Transformer has a reject link.
D) The target stage variable is populated with spaces or zeros depending on the stage variable data type.
2. Which of the following statements about Collecting methods is correct?
A) SORT MERGE never performs data sorting
B) AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and ORDERED
C) ROUND ROBIN is the fastest algorithm
D) ORDERED ensures the collected data stream being sorted
3. Which of the following is a standard practice when using partition parallelism?
A) All of the above
B) Avoid repartitioning if possible
C) Disable the pipeline parallelism for all the stages that can run in parallel
D) Setup a configuration file defining multiple CPUs for each logical node
4. In DataStage Sequential File Stage, how is a NULL value represented?
A) By a 'NULL' string
B) By a space character
C) A -1 for an integer field and an empty string for a VARCHAR field
D) As defined by the Developer in the extended properties of the field
5. How can FastTrack speed up the process of creating new source-to-target mapping specifications? I.Reverse engineer existing DataStage jobs II.Automatically discover column mappings using matches on column names III.Leverage metadata imported from other Information Server modules IV.FastTrack automatically converts data lineage reports into mapping specifications
A) I, II, III, IV
B) I, II, III
C) I, II, IV
D) II, III, IV
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: A | 질문 # 3 정답: B | 질문 # 4 정답: D | 질문 # 5 정답: B |