C2090-303 Exam Questions

A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a...

Which partitioning method requires a key?

A job design consists of an input Row Generator stage, a Sort stage, followed by a Transformer stage and an output Data Set stage. The job is run on an SMP machine with a configura...

The data going into the target Sequential Files stage is range-partitioned and sorted. Which technique method would be the most efficient to create a globally sorted target sequent...

In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File stage with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset...

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

Which two actions are available when editing a message handler? (Choose two.)

What is the result of running the following command: dsjob -report DSProject ProcData

You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are two valid ways to do this? (Choose two.)

On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes yo...

You are working on 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...

Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Befo...

Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?

Which statement is true when using the SaveInputRecord() function in a Transformer stage.

In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger which two actions. (Choose two.)

Which derivations are executed first in the Transformer stage?

You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How c...

When you configure a domain for source code integration a source control workspace is created. What are two reasons for the source control workspace? (Choose two.)

Where are project level message handlers defined?

What is the purpose of the APT_DUMP_SCORE environment variable?

Suppose a user ID has been created with DataStage and QualityStage component authorization. Which client application would be used to give that user ID DataStage Developer permissi...

Which two data repositories can be used for user authentication within the Information Server Suite? (Choose two.)

Which two statements are true about the use of named node pools? (Choose two.)

Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

Which method is used to specify when to stop a job because of too many rejected rows with an ODBC Connector?

Which two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

Which requirement must be met to read from a database in parallel using the ODBC connector?

Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Cho...

Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)

The parallel framework was extended for real-time applications. Identify two of these aspects. (Choose two.)

The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are two change values identified by these code values? (Choos...

What stage allows for more than one reject link?

A 100MB input dataset has even distribution across 400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this sc...

Which statement is correct about the Data Rules stage?

Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

The ODBC stage can handle which two SQL Server data types? (Choose two.)

Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?

Which Oracle data type conversion is correct?

Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)

Which Oracle Connector stage property can be set to tune job performance?

In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option is turned off. What happens when a row is processed tha...

Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

When using the loop functionality in a transformer, which statement is true regarding Transformer processing.

In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format proper...

Which stage classifies data rows from a single input into groups and computes totals?

Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

Which derivations are executed last in the Transformer stage?

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

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

Which statement is true about table definitions created in DataStage Designer?