C2090-303 Exam Questions

What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

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

What role must a user have to delete shared metadata assets from the repository?

Your job is using the Sequential File stage as a source. Identify two stage property configurations that will allow you to accomplish parallel reads? (Choose two.)

Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

When using the Sequential File stage as a source, what two property options allow you to add extra columns about the file(s) you are reading onto the output link? (Choose two.)

The parallel framework supports standard and complex data types in the SQL type column tab property. Identify the two complex data types? (Choose two.)

How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?

Identify two areas that DataStage can integrate with a Hadoop environment. (Choose two.)

You are using the Complex Flat File stage as a source in your job. What are two types of data specifically supported by the Complex Flat File stage for your job? (Choose two.)

The number of File Set data files created depends upon what two items? (Choose two.)

What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)

Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using...

What are two statistics or attributes that can be added to the output of a Data Rule stage? (Choose two.)

What are two properties dependent of both Column for Calculation and Summary Column for Recalculation? (Choose two.)

A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could...

Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)

What are the valid join operations for the Join stage? (Choose two.)

Which statement is true about creating DataStage projects?

You are editing the configuration file. Which statement is true about file system efficiency?

Which statement is true about Information Server logging?

What is used to configure the DataStage QualityStage Operations Console?

What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)

The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links,expanding the icon borde...

You have created three parallel jobs (Job A, B and C) in which the output of one job is the input to the other job. You are required to create processing that manages this data rel...

Which statement is true about improving job performance when using Balanced Optimization?

In your parallel job design you have selected a parallel shared container to be included. Which area of your job design is required to be configured to use the parallel shared cont...

A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a ISD output stage. How can the parameter values can be passed to...

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.)

Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?

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?

You would like to run a particular processing job within a job sequence for each weekday. What two methods could be used? (Choose two.)

When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What message handler level is available?

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.)

What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)

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...

You have made a copy of your job and made major changes to a job in your project. You now want to identify all the changes that have been made. What task will allow you to identify...

What two Information Server tools can be used to create deployment packages for DataStage jobs? (Choose two.)

Two new columns have been deleted from a sequential file that a number of DataStage jobs write to. You have imported a table definition for the changed file. How can you determine...

A job using a one-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to three different sequential files. How...

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...

A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, th...

A job using a three-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to two different sequential files. How...

Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and Pro...

What two computer system resources on the DataStage engine are monitored in the Operations Console? (Choose two.)

You want to better understand the tsort operators that are inserted into the job flow at runtime. Which environment variable can provide this information?

Which job log message heading identifies the score in the job log?

What would help debug the run-time environment?

DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)