C2090-303 Exam Questions
139 real C2090-303 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #103
Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)
- Question #104
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...
- Question #105
When optimizing a job, Balanced Optimization will NOT search the job for what pattern?
- Question #106
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...
- Question #107
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...
- Question #109
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...
- Question #110
You are asked by management to document all jobs written to make future maintenance easier. Which statement is true about annotations?
- Question #111
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?
- Question #112
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...
- Question #113
What two features distinguish the Operations Console from the Director job log? (Choose two.)
- Question #114
The Score is divided into which two sections? (Choose two.)
- Question #115
Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)
- Question #116
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...
- Question #117
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...
- Question #119
How is DataStage table metadata shared among DataStage projects?
- Question #120
Which two parallel job stages allow you to use partial schemas? (Choose two.)
- Question #121
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.)
- Question #122
When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)
- Question #124
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...
- Question #126
Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)
- Question #127
When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)
- Question #128
Which two statements are true about Data Sets? (Choose two.)
- Question #129
What is the correct method to process a file containing multiple record types using a Complex Flat File stage?
- Question #130
When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)
- Question #131
Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)
- Question #132
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.)
- Question #133
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?
- Question #134
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...
- Question #135
In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)
- Question #137
Which two statements are true about stage variables in a Transformer Stage? (Choose two.)
- Question #138
Which three of the following options does the dsjob command have? (Choose three.)
- Question #139
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...
- Question #140
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...
- Question #142
In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)
- Question #143
Which of the following is not an ODBC connector property?
- Question #144
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?
- Question #145
Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)
- Question #146
Which two partitioning methods require keys? (Choose two.)
- Question #147
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...