A2090-421 by IBM Actual Free Exam Questions And Answers

Question 1

You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?

A. From Designer Tools, open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.

B. Open the Table Definition properties, Select the ADDRESS column, then right click and select Find where used.

C. Select a Table Definition, then right click and choose Find where column is used. Select the column to search for from the list.

D. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.

Discussion 0

Correct Answer: D Vote an answer

Question 2

You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic?

A. Create parallel routines.

B. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic.

C. Create parallel shared containers and define columns combining all data formats.

D. Create separate jobs and choose appropriate job within a job sequence.

Discussion 0

Correct Answer: B Vote an answer

Question 3

In a file defining a partial schema, which three properties define the record? (Choose three.)

A. text

B. delim

C. intact

D. record_length

E. record_delim_string

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 4

What are the three features of Information Server that allow you to deploy DataStage objects? (Select three)

A. $APT_COPY_TRANSFORMER

B. dscc.exe

C. Designer Client Export

D. istool

E. Information Server Manager

Discussion 0

Correct Answer: B,E Vote an answer

Question 5

A copy of a production job was moved into a development project and modified to improve performance. You must prepare a report for a code review that documents the changes to the job.
How would you gather the information for this report? (Select two)

A. DSMakeJobReport

B. Compare Within

C. Cross Project Compare

D. diffapicmdline.exe

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)

A. Define a non-default node pool with a subset of nodes in the parallel configuration file.

B. Assign a separate config file just for the Sort stage.

C. Create a sort scratch disk pool with a subset of nodes in the parallel configuration file.

D. Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE.

E. Have an appropriate node constraint within the Sort stage.

Discussion 0

Correct Answer: A,E Vote an answer

Question 7

You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?

A. Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.

B. Select the shared container, Right-click on the Where used command.

C. Select the shared container, Right-click on the Dependencies (deep) command.

D. Select the shared container, Right-click on the Where used (deep) command.

Discussion 0

Correct Answer: D Vote an answer

Question 8

In which two situations would you use the Web Services Client stage? (Choose two.)

A. You want to deploy a service.

B. You do not need both input and output links in a single web service operation.

C. You need the Web service to act as either a data source or a data target during an operation.

D. You need to create a WSDL.

Discussion 0

Correct Answer: B,C Vote an answer

Question 9

Which three statements are true about characteristics of shared containers? (Select three)

A. Containers allow you to provide pre-configured job design logic.

B. Containers are used to execute jobs.

C. Containers allow multiple users to access a single job.

D. Containers allow you to implement recurring logic.

E. Containers are a group of stages and links.

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

A. The related elements are output as arrays.

B. CFF does not support this clause.

C. The related elements are output as denormalized fields.

D. The related elements are output as subrecords.

Discussion 0

Correct Answer: A Vote an answer

Question 11

What stage allows for more than one reject link?

A. Peek stage

B. Funnel stage

C. Merge stage

D. Lookup stage

E. Join stage

Discussion 0

Correct Answer: C Vote an answer

Question 12

Click on the Exhibit button.

Which environment variable would provide this information?

A. APT_DEBUG_PARTITION

B. APT_STATUS

C. APT_PM_PLAYER_TIMING

D. APT_SHOW_COMPONENT_CALLS

Discussion 0

Correct Answer: C Vote an answer

IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test

Contact Us

Useful Links

Latest Updated