What are three valid data types for "Calculation" Aggregation type in the Aggregator stage? (Choose three.)
A. Integer
B. Date
C. Char
D. Decimal
E. Varchar
正解:A,B,D
質問 2:
You have been asked to identify all of the job objects that use a particular Table Definition. This task must be performed to evaluate the impact of this layout change for your DataStage application. To accomplish this task, which two steps must have been completed by the job developers to allow you to locate all of the jobs associated with the table definition? (Choose two.)
A. The job stage cross reference properties must be entered using the Table Definition name.
B. The Table Definition object must be created.
C. The Cross Reference object must be created.
D. The job stage column tab properties must be entered using 'Load' button within the Table Definition.
正解:B,D
質問 3:
A client must support multiple languages in selected text columns when reading from DB2 database. Which two actions will allow selected columns to support such data? (Choose two.)
A. Choose Unicode setting in the extended column attribute.
B. Click NLS support within the advanced column tab.
C. NLS must be added in the Additional Connection Options of the database operator.
D. Choose NVar/NVarchar as data types.
正解:A,D
質問 4:
A customer wants to select the entire order details for the largest transaction for each of 2 million unique customers from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?
A. Partition on customer key, sort on customer key and transaction amount, Remove duplicates on customer key.
B. Partition and Sort the input to a Remove Duplicates stage using the customer key and transaction amount columns. Remove duplicates on customer key.
C. Partition and Sort the input to a Filter stage by customer number. Filter with the clause "MAX(transaction_amount)".
D. Use a Sort Aggregator stage with a calculated column based on the maximum value of the transaction amount column.
正解:A
質問 5:
You are assigned to write a job that splits a single Data Set into three Data Sets based on character values on the input record. Normally you would use a transformer link constraint to achieve this but you discover that the condition for each output link is supplied at runtime. Which stage would allow you to parameterize the entire condition for splitting the input data set?
A. Modify
B. Match Frequency
C. Filter
D. Split Vector
正解:C
質問 6:
Your customer asks you to identify which stages in a job are consuming the largest amount of CPU time. Which product feature would help identify these stages?
A. $APT_PM_PLAYER_CPU
B. $APT_PM_PLAYER_TIMING
C. $APT_PM_DUMP_SCORE
D. $APT_PM_SHOW_PIDS
正解:B
Okada -
C2090-418出題強化に対応! 初受験にもリトライにも使えると思います。合格しました。Pass4Testさんのおかげです