Click the Exhibit button.
In the exhibit, a Funnel stage has two Input Links. Input 1(Seq_File) comes from a sequential file with set "Readers per Node" set to "2" , Input 2(Dataset) comes from a Data Set created in parallel (three-way parallel). Within 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
正解:B
質問 2:
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
質問 3:
You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?
A. In the Director, use the Find feature.
B. Use the Advanced Find feature contained in the Designer interface.
C. Sort the jobs by date.
D. Query the VOC with the appropriate parameters.
正解:B
質問 4:
Your customer requires you to read a delimited sequential file. Which property would you select to enable parallel reading of a delimited sequential file?
A. External Source
B. Multiple readers per node
C. Round Robin
D. Read from multiple nodes
正解:B
質問 5:
Click the Exhibit button.
Based on the dump score fragment provided in the exhibit, which two operators were added by the Parallel Framework during runtime to satisfy the Join stage execution requirements? (Choose two.)
A. Tsort
B. Buffer
C. APT_RealFileExportOperator
D. APT_JoinSubOperatorNC
正解:A,B
質問 6:
What is the lowest cost partitioning method for parallel stage to sequential stage?
A. Ordered
B. Round Robin
C. SortMerge
D. Entire
正解:B
質問 7:
Your job reads from a file using a Sequential File stage running sequentially. You are using a Transformer stage following the Sequential File stage to format the data in some of the columns. What is the default (Auto) partitioning method?
A. Random
B. Hash
C. Round Robin
D. Same
正解:C
1306 お客様のコメント





冈田** -
私を合格させることに成功しました。優秀なC2090-418問題集です!合格になりました!友達もC2090-418問題集を勉強しています。