IBM Certified Solution Developer - IBM InfoSphere DataStage Sample Questions:
1. Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?
A) You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.
B) An input column value flows into a target column only if it matches it by name.
C) An input column value flows into a target column only if it is explicitly mapped to it.
D) An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.
2. Your job will write its output to a fixed length data file. When configuring the sequential file stage as a target what format and column tab properties need to be considered for this type of file output?
A) On the Output Link format tab, add the 'Record Type' property to the tree and set its value to be 'F'.
B) On the Output Link format tab, change the 'Delimiter' property to whitespace.
C) On the Output Link column tab, specify the record size total based on all of the columns defined
D) On the Output Link column tab, insure that all the defined column data types are fixed length types.
3. Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)
A) A job with greater then one ISD input stage and one ISD Output stage.
B) A job with a single ISD Transformation stage.
C) A job with one ISD Input stage and no ISD Output stage.
D) A job with no ISD Input stage and with one ISD Output stage.
E) A job with one ISD Input stage and greater then one ISD Output stage.
4. Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?
A) Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.
B) Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.
C) Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
D) Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.
5. Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)
A) Compare Stage
B) Complex Flat File Stage
C) Big Data File Stage
D) Lookup File Set Stage
E) Data Set Stage
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: C,D | Question # 4 Answer: A | Question # 5 Answer: B,C |
0 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
