Tested of C2090-303 exam answers materials and questions pool for IBM certification for IT learners, 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:
Q1. - (Topic 2)
The parallel framework supports standard and complex data types in the SQL typecolumn tab property. Identify the two complex data types? (Choose two.)
A. Vector
B. VarChar
C. Linked list
D. Subrecord
E. Binary trees
Answer: A,D
Q2. - (Topic 2)
In a file defining a partial schema, which two properties define the record? (Choose two.)
A. intact
B. delim
C. position
D. length_of_record
E. record_delim_string
Answer: A,E
Q3. - (Topic 1)
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. Returns a report ofthe last run of the ProcData job in a DataStage project named DSProject.
C. Runs the DataStage job named ProcData and returns performance information, including the number of rows processed.
D. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.
Answer: B
Replace C2090-303 torrent:
Q4. - (Topic 1)
When using a Sequential File stage as a source what are the two rejectmode property options? (Choose two.)
A. Set
B. Fail
C. Save
D. Convert
E. Continue
Answer: B,E
Q5. - (Topic 2)
You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. What aretwo requirements on the input link data for the Change Capture stage? (Choose two.)
A. sorted
B. merged links
C. parallel mode
D. key partitioned
E. sequential mode
Answer: A,D
Q6. - (Topic 2)
A job design consists of an input Sequential Files stage, a Sort stage,followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
A. 6
B. 8
C. 10
D. 12
Answer: B
Vivid C2090-303 training materials:
Q7. - (Topic 1)
A 100MB input dataset has even distribution across400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose two.)
A. Convert all numeric fields to varchars.
B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.
C. Alter the Sortstage properties to perform a stable sort.
D. Specify Round Robin partitioning on the input link to the Sort stage.
E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
Answer: B,E
Q8. - (Topic 2)
What two Information Server tools can be used to create deployment packages for DataStage jobs? (Choose two.)
A. istool
B. Information Server Console
C. Information Server Manager
D. InfoSphere Metadata Assset Manager
E. Information Server Web Console - Administration tab
Answer: A,C
Q9. - (Topic 2)
In your job you are using a Sequential File stage as a source. You have decided to use a schema file as analternative 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. Enable Run Time Column propagation.
B. Enable Run Time Schema propagation.
C. Configure the column tab with one column named 'Input'.
D. Configure the Schema File property with the path of the schema file definition.
E. Configure the APT_SEQFILE_HASSCHEMA property with the schema file path.
Answer: A,D
Q10. - (Topic 2)
Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?
A. Job parameters should be used in JobNames.
B. Hard code the Invocation ID to improve development process.
C. Create a standard directory structure inside of the DataStage project directory for source and target files.
D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.
Answer: D