Exam Code: C2090-303 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere DataStage v9.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-303 Exam.
2021 Apr C2090-303 Study Guide Questions:
Q81. - (Topic 2)
Which two commands start a DataStage job named procRows in a project named
DSProject. It also passes the value 200 to the numRows parameter. (Choose two.)
A. dsjob -run -paramfile numRows=200 DSProject procRows
B. dsjob-run -mode normal -param numRows=200 DSProject procRows
C. dsjob -run -mode validate -param numRows=200 DSProject procRows
D. dsjob -run -mode normal -paramfile numRows=200 DSProject procRows
E. dsjob -run -queue HighPriority -param numRows=200 DSProjectprocRows
Answer: B,E
Q82. - (Topic 1)
What is the purpose of the APT_DUMP_SCORE environment variable?
A. There is no such environment variable.
B. It is an environment variable that turns on the job monitor.
C. It is an environment variable that enables the collection of runtime performancestatistics.
D. It is a reporting environment variable that adds additional runtime information in the job log.
Answer: D
Q83. - (Topic 1)
A job design consists of an input Row Generator stage, a Sort stage, followed by a Transformer stage and an output Data Set stage. The job is run on an SMP machine with a configuration file defined with fournodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
A. 7
B. 16
C. 13
D. 16
Answer: C
Updated C2090-303 free question:
Q84. - (Topic 2)
How must the input data set be organized for input into the Join stage? (Choose two.)
A. Unsorted
B. Key partitioned
C. Hash partitioned
D. Entire partitioned
E. Sorted by Join key
Answer: B,E
Q85. - (Topic 2)
The ODBC stage can handle which two SQL Server data types? (Choose two.)
A. Date
B. Time
C. GUID
D. Datetime
E. SmallDateTime
Answer: C,E
Q86. - (Topic 2)
Click on the Exhibit button.
Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?
A. 2
B. 3
C. 4
D. 5
Answer: B
Certified C2090-303 pdf:
Q87. - (Topic 2)
Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)
A. Split Vector
B. Column Import
C. Merge records
D. Split Subrecord
E. Make Subrecord
Answer: D,E
Q88. - (Topic 2)
How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?
A. Each element of the OCCURS clause is treated as a subrecord.
B. The CFF stage cannot process COBOL files with OCCURS clauses.
C. Each element of the OCCURS clause is treated as a column of raw data.
D. Each element of the OCCURS clause is treated as a separate element in an array.
Answer: D
Q89. - (Topic 2)
What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)
A. $APT_NO_PART_INSERTION
B. $APT_OPT_SORT_INSERTION
C. $APT_RESTRICT_SORT_USAGE
D. $APT_PARTITION_FLUSH_COUNT
E. $APT_TSORT_STRESS_BLOCKSIZE
Answer: A,E
Q90. - (Topic 2)
Which statement is true about improving job performance when using Balanced Optimization?
A. Convert a job to use bulk staging tables for Big Data File stages.
B. Balance optimization attempts to balance the work between the source server, target sever, and the job.
C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.
D. To ensure that a particular stage can only be pushed into a sourceor target connector, you can set the Stage Affinity property to source or target.
Answer: D