Actual of C2090-303 study guide materials and practice for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-303 pdf dumps vce Materials. 100% PASS IBM InfoSphere DataStage v9.1 exam Today!
2021 Apr C2090-303 Study Guide Questions:
Q61. - (Topic 1)
You are asked to optimizethe 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 on the input links to the Aggregator and Join stages.
C. Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on 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.
Answer: D
Q62. - (Topic 2)
What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)
A. EJB
B. SQL
C. HDFS
D. SOAP
E. STREAMS
Answer: A,D
Q63. - (Topic 2)
The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2).
Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option is turned off. Which behavior is expected?
A. The job aborts.
B. NULL is written to the target stage variable.
C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.
D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.
Answer: B
Leading C2090-303 free exam questions:
Q64. - (Topic 2)
You have finished changes to many jobs and shared containers. You must export all of your changes and integrate them into a test project with other objects. Whatis a way to select the objects you changed for the export?
A. Sort the jobs by timestamp.
B. Open Quick Find and select "Types to Find".
C. Use Multiple Job Compile to locate objects that need to be compiled.
D. Using the advanced find dialog, specify inthe last modified panel, the date range of the jobs, and appropriate user name.
Answer: D
Q65. - (Topic 2)
You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which technique will enable you to retrieve the sum of the last group?
A. Output the sum that you generated each timeyou process a row for which the LastRow() function returns True.
B. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.
C. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
D. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the FirstRow() function to determine when thegroup is done.
Answer: C
Q66. - (Topic 2)
What aretwo advantages of using Runtime Column Propagation (RCP)? (Choose two.)
A. RCP forces a developer to define all columns explicitly.
B. Only columns used in the data flow need to be defined.
C. Sequential files don't require schema files when using RCP.
D. Only columns that are defined as VarChar need RCP enabled.
E. Columns not specifically used in the flow are propagated as if they were.
Answer: B,E
Exact C2090-303 Q&A:
Q67. - (Topic 2)
Which statement is true about table definitions created in DataStage Designer?
A. By default, table definitions created in DataStage Designer are visible to other Information Server products.
B. Table definitions created in DataStage Designer are local to DataStage and cannot be shared with other Information Server products.
C. When a table definition is created in one DataStage project, it is automatically available in other DataStage projects, but not outside of DataStage.
D. Table definitions created in DataStage Designer are not by default available to other InformationServer products, but they can be shared with other Information Server products.
Answer: D
Q68. - (Topic 1)
What is the correct method to process a file containing multiple record types using a Complex Flat Filestage?
A. Flatten the record types into a single record type.
B. Manually break the file into multiple files by record type.
C. Define record definitions on the Constraints tab of the Complex Flat File stage.
D. Load a table definition for each record type on the Records tab of the Complex Flat File stage.
Answer: D
Q69. - (Topic 2)
You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What step should you take to understand the job performance issues?
A. Replace Join stages by Lookup stages.
B. Run the job with $APT_TRACE_RUN set to true.
C. Run the job with $APT_DUMP_SCORE set to true.
D. Replace Transformer stages with custom operators.
Answer: C
Q70. - (Topic 1)
Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable".Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)
A. Set the Job1 Activity stage to "Do not checkpoint run".
B. Set trigger on the Job1 Activity stage to "Unconditional".
C. In the Job1 Activity stage set the Execution action to "Run".
D. In the Job1 Activity stage set the Execution action to "Reset if required, then run".
E. Use the Nested Condition Activity with a trigger leading to Job1; setthe trigger expression type to "Unconditional".
Answer: A,D