Online Access Free A2090-303 Practice Test

The data going into the target Sequential File stage is sorted in each partition by the Date field. You want the data in the sequential file to be sorted by Date. Which collection algorithm should you choose in the Sequential File stage?

• A.Ordered
• B.Round Robin
• C.Auto
• D.Sort Merge

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. What is a way to select the objects you changed for the export?

• A.Use Multiple Job Compile to locate objects that need to be compiled.
• B.Using the advanced find dialog, specify in the last modified panel, the date range of the jobs, and appropriate user name.
• C.Open Quick Find and select "Types to Find".
• D.Sort the jobs by timestamp.

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 -mode normal -paramfile numRows=200 DSProject procRows
• B.dsjob -run -queue HighPriority -param numRows=200 DSProject procRows
• C.dsjob -run -mode normal -param numRows=200 DSProject procRows
• D.dsjob -run -paramfile numRows=200 DSProject procRows
• E.dsjob -run -mode validate -param numRows=200 DSProject procRows

Which derivations are executed last in the Transformer stage?

• A.Output column derivations
• B.Loop variable derivations
• C.Stage variable derivations
• D.Input column derivations

When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)

• A.DB2 Connector stage
• B.Peek stage
• C.Sequential File stage
• D.Column Import stage
• E.Pivot stage