C2090-303 Exam Questions

Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)

In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation...

When optimizing a job, Balanced Optimization will NOT search the job for what pattern?

You are asked to optimize the 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...

You have a parallel job that based on operational recoverability requirements needs to be broken up into two separate parallel jobs. You have decided to use the Data Set stage to s...

You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates...

You are asked by management to document all jobs written to make future maintenance easier. Which statement is true about annotations?

You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on pro...

What two features distinguish the Operations Console from the Director job log? (Choose two.)

The Score is divided into which two sections? (Choose two.)

Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)

A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring reveals that some partitions process many...

You are asked by your customer to collect partition level runtime metadata for DataStage parallel jobs. You must collect this data after each job completes. What two options allow...

How is DataStage table metadata shared among DataStage projects?

Which two parallel job stages allow you to use partial schemas? (Choose two.)

In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

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

Your job will write its output to a fixed length data file. When configuring the sequential file stage as a target what format and column tab properties need to be considered for t...

Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)

Which two statements are true about Data Sets? (Choose two.)

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)

Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)

Identify two items that are created as a result of running a Balanced Optimization on a job that accesses a Hadoop distributed file system as a source? (Choose two.)

A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of...

In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

Which two statements are true about stage variables in a Transformer Stage? (Choose two.)

Which three of the following options does the dsjob command have? (Choose three.)

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

Click the Exhibit button. The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You...

In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)

Which of the following is not an ODBC connector property?

You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?

Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

Which two partitioning methods require keys? (Choose two.)

A job design consists of an input sequential file, a Modify stage, followed by a Filter stage and an output SequentialFile stage. The job is run on an SMP machine with a configurat...