최신 IBM Information Management P2090-046 무료샘플문제:
1. You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which three techniques will enable you to retrieve the sum of the last group? (Choose three.)
A) Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.
B) Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.
C) Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.
D) Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
E) Output the sum that you generated each time you process a row for which the LastRow() function returns True.
2. Which tool below can be used to assign permissions to users for each DataStage project?
A) DataStage Designer
B) Information Server Web Console
C) DataStage Director
D) DataStage Administrator
3. 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
4. In DataStage, Table Definitions can be imported through __________.
A) DataStage Designer
B) Information Server Web Console
C) DataStage Director
D) DataStage Administrator
5. Which of the following statements about FastTrack is incorrect?
A) The only way to combine data in a FastTrack mapping specification is to create a lookup definition
B) When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems
C) Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations
D) When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)
질문과 대답:
| 질문 # 1 정답: A,B,D | 질문 # 2 정답: D | 질문 # 3 정답: D | 질문 # 4 정답: A | 질문 # 5 정답: A |
768 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
