최신 IBM Specialist A2090-421 무료샘플문제:
1. Where are project level message handlers defined?
A) DSENV
B) Director Client
C) Designer Client
D) Administrator Client
2. Refer to the exhibit.
You are responsible for improving performance for a given job. From reviewing the job dump score, you notice that many tsort operators are inserted. Join_1 is on columns "account", "po_date" and "hdr_number". Join_2 is based on "account", "hdr_number", "paid_date".
Which two actions will help you improve the performance without changing the business logic?
(Select two)
A) Partition on account and hdrnumber for all joins. Change Join_1 to join on "account", "hdrnumber" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account" and "hdr_number" and sort on "paid_date".
B) Insert sort stage between Join_1 and Join_2, subsort ("Don't sort, previously sorted") on "account", sort "hdr_number" and "paid_date".
C) Partition on account and hdr_numberfor all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account".
D) Partition on "account" and "hdr_number" for all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Add Add $APT_SORTJNSERTION_CHECK_ONLY to job parameter list and set it to "True".
3. In a Transformer, which two of the following mappings can be handled by default type conversions. (Select two)
A) String input column mapped to a data output column.
B) Integer input column mapped to string output column.
C) String input column mapped to integer output column.
D) Integer input column mapped to raw output column.
E) Date input column mapped to a string output column.
4. The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?
A) Load
B) Update
C) Insert
D) Delete
5. In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a SequentialFile with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. With the Funnel stage, the funnel type is set to "Sequence". The parallel configuration file contains three nodes.
How many instances of the Funnel stage run in parallel?
A) 1
B) 3
C) 6
D) 2
질문과 대답:
질문 # 1 정답: D | 질문 # 2 정답: A,D | 질문 # 3 정답: A,B | 질문 # 4 정답: A | 질문 # 5 정답: B |