What is the result of running the following command: dsjob -report DSProject ProcData
A. Generates a report about the ProcData job, including information about its stages and links.
B. Runs the DataStage job named ProcData and returns performance information, including the number of rows processed.
C. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.
D. Returns a report of the last run of the ProcData job in a DataStage project named DSProject.
正解:D
質問 2:
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.

Which change will reduce the cost of partitioning that occurs in this job?
A. Use Entire partitioning on the input links to the Aggregator and Join stages.
B. Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
C. Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
正解:D
質問 3:
Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?
A. Create a standard directory structure inside of the DataStage project directory for source and target files.
B. Job parameters should be used in Job Names.
C. Hard code the Invocation ID to improve development process.
D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.
正解:D
質問 4:
Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)
A. $OSH_EXPLAIN
B. $APT_PM_STARTUP_CONCURRENCY
C. $APT_EXPORT_FLUSH_COUNT
D. $APT_STARTUP_STATUS
E. $APT_IO_MAP
正解:A,D
質問 5:
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 one ISD Input stage and greater then one ISD Output stage.
C. A job with no ISD Input stage and with one ISD Output stage.
D. A job with a single ISD Transformation stage.
E. A job with one ISD Input stage and no ISD Output stage.
正解:C,E
質問 6:
A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
A. 8
B. 16
C. 10
D. 12
正解:A
質問 7:
What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)
A. Information Server metadata Repository
B. WebSphere Repository
C. Source Code Repository
D. Universe Project Repository
E. Information Analyzer Repository
正解:A,C
質問 8:
Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)
A. It includes the XML Input, XML Output, and XML Transformer stages.
B. XML Stages are Plug-in stages.
C. A single XML Stage, which can be used as a source, target, or transformation.
D. XML Stage can be found in the Database folder on the palette.
E. Uses a unique custom GUI interface called the Assembly Editor.
正解:C,E
質問 9:
In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)
A. Configure the APT_SEQFILE_HASSCHEMA property with the schema file path.
B. Configure the Schema File property with the path of the schema file definition.
C. Configure the column tab with one column named 'Input'.
D. Enable Run Time Schema propagation.
E. Enable Run Time Column propagation.
正解:B,E
Takebe -
勉強する本にこんな表現もないですが
まさにお買い得なPass4TestさんのC2090-303問題集だなって思いました。