Printable of C2090-303 braindumps materials and bootcamp for IBM certification for IT professionals, Real Success Guaranteed with Updated C2090-303 pdf dumps vce Materials. 100% PASS IBM InfoSphere DataStage v9.1 exam Today!
2021 May C2090-303 Study Guide Questions:
Q11. - (Topic 1)
Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?
A. An input column value flows into a target column only if it matches it by name.
B. An input column value flows into a target columnonly if it is explicitly mapped to it.
C. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.
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.
Answer: B
Q12. - (Topic 1)
Your job will write its output to a fixed length data file. When configuring the sequential file stage as a target whatformat and column tab properties need to be considered for this type of file output?
A. On the Output Link format tab, change the 'Delimiter' property to whitespace.
B. On the Output Link format tab, add the 'Record Type' property to the tree and set itsvalue to be 'F'.
C. On the Output Link column tab, insure that all the defined column data types are fixed length types.
D. On the Output Link column tab, specify the record size total based on all of the columns defined
Answer: C
Q13. - (Topic 2)
Which Oracle Connector stage property canbe set to tune job performance?
A. Array size
B. Memory size
C. Partition size
D. Transaction size
Answer: A
Far out C2090-303 exam:
Q14. - (Topic 2)
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 TotalAmount. Sort on CustID, ProductType and TotalAmount.
C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
D. Hash-partition on CustID, ProductTypeand TotalAmount. Sort on CustID, ProductType and TotalAmount.
Answer: A
Q15. - (Topic 1)
Which two statements are true about Data Sets? (Choose two.)
A. Data sets contain ASCII data.
B. Data Sets preserve partitioning.
C. DataSets require repartitioning.
D. Data Sets represent persistent data.
E. Data Sets require import/export conversions.
Answer: B,D
Q16. - (Topic 1)
On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?
A. Compare Against
B. diffapicmdline.exe
C. DSMakeJobReport
D. Cross Project Compare
Answer: D
Vivid C2090-303 questions pool:
Q17. - (Topic 1)
The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are two change values identified by these code values? (Choose two.)
A. Edit
B. Final
C. Copy
D. Deleted
E. Remove Duplicates
Answer: C,D
Q18. - (Topic 2)
Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)
A. A job with a single ISD Transformation stage.
B. Ajob with one ISD Input stage and no ISD Output stage.
C. A job with no ISD Input stage and with one ISD Output stage.
D. A job with greater then one ISD input stage and one ISD Output stage.
E. A job with one ISD Input stage and greater then one ISD Outputstage.
Answer: B,C
Q19. - (Topic 1)
Which two parallel job stages allow you to use partial schemas? (Choose two.)
A. Peek stage
B. File Set stage
C. Data Set stage
D. Column Export stage
E. External Target stage
Answer: B,E
Q20. - (Topic 2)
Identify the two statements that are true about the functionality of the XML Pack 3.0.(Choose two.)
A. XML Stages are Plug-in stages.
B. XML Stage can be found in the Database folder on the palette.
C. Uses a unique custom GUI interface called the Assembly Editor.
D. It includes the XML Input, XML Output, and XML Transformer stages.
E. A single XML Stage, which can be used as a source, target, or transformation.
Answer: C,E