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 May C2090-303 Study Guide Questions:
Q71. - (Topic 1)
Which derivations are executed first in the Transformer stage?
A. Input columnderivations
B. Loop variable derivations
C. Stage variable derivations
D. Output column derivations
Answer: C
Q72. - (Topic 1)
The parallelframework was extended for real-time applications. Identify two of these aspects. (Choose two.)
A. XML stage.
B. End-of-wave.
C. Real-time stage types that re-run jobs.
D. Real-time stage types that keep jobs always up and running.
E. Support fortransactions within source database connector stages.
Answer: B,D
Q73. - (Topic 1)
Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)
A. Sum
B. Maximum Value
C. Average of Weights
D. Coefficient of Variation
E. Uncorrected Sum of Squares
Answer: A,E
Up to date C2090-303 practice exam:
Q74. - (Topic 2)
What are two statistics or attributes that can be added tothe output of a Data Rule stage? (Choose two.)
A. Record ID
B. System timestamp
C. Number of violations
D. Job execution owner
E. Percentage of violations
Answer: A,B
Q75. - (Topic 1)
Which requirement must be met to read from a database in parallel using the ODBC connector?
A. ODBC connector always reads in parallel.
B. Set the Enable partitioning property to Yes.
C. Configure environment variable $APT_PARTITION_COUNT.
D. Configure environment variable$APT_MAX_TRANSPORT_BLOCK_SIZE.
Answer: B
Q76. - (Topic 1)
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 AssemblyEditor.
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
Pinpoint C2090-303 forum:
Q77. - (Topic 1)
Which twodata repositories can be used for user authentication within the Information Server Suite? (Choose two.)
A. IIS Web Console
B. IBM Metadata repository
C. Standalone LDAP registry
D. Operations Console database
E. IBM Information Server user directory
Answer: C,E
Q78. - (Topic 2)
You would like to run a particular processing job within a job sequence for each weekday. What two methods could be used? (Choose two.)
A. Set the frequency property in the job scheduler to weekdays only.
B. Add thejob scheduler stage to the job sequence and set to weekdays only.
C. Call a routine in the job sequencer that starts the processing job for each day you would like to process.
D. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.
E. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.
Answer: C,E
Q79. - (Topic 1)
Which two environment variables add additionalreporting information in the job log for
DataStage jobs? (Choose two.)
A. $APT_IO_MAP
B. $OSH_EXPLAIN
C. $APT_STARTUP_STATUS
D. $APT_EXPORT_FLUSH_COUNT
E. $APT_PM_STARTUP_CONCURRENCY
Answer: B,C
Q80. - (Topic 1)
You are workingon a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by a former developer of the project. How can you find these jobs?
A. Sort the jobs by date in the Repository window.
B. Use AdvancedFind feature in the Designer interface.
C. Select the top project folder and choose Find Dependencies (deep).
D. Right-click on jobs folder in the Repository window and select Filter jobs.
Answer: B