InfoSphere DataStage v8.5 - C2090-421 Exam Practice Test

Question 1

The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

A. Aggregates and most arithmetic operators in the SELECT statement are allowed.

B. Multiple-AMP requests are allowed.

C. Non-data access (e.g., pseudo-tables like DATE or USER) is allowed.

D. The use of the USING modifier is allowed.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

You are setting up project defaults. Which three items can be set in DataStage Administrator? (Choose three.)

A. default prompting options, such as Autosave job before compile

B. default for Runtime Column Propagation

C. default for compile options

D. defaults for environment variables

E. suite roles

Correct Answer: B,C,D

Question 3

Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

A. An update that overwrites the existing column value.

B. An update that retains the existing column value in a list and adds the new value to the list.

C. An update the retains the existing column value in an historical row and creates a new row with the new value.

D. An update that replaces the existing column value if a specified condition is satisfied.

Correct Answer: B

Question 4

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

A. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.

B. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.

C. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.

D. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.

Correct Answer: C,D

Question 5

You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)

A. Columns must be in consecutive order.

B. Input columns must form a numeric sequence.

C. Input columns must all be of the same data type.

D. Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.

E. All columns are combined into a vector of the same length as the number of columns.

Correct Answer: B,C,E

Question 6

Click the exhibit button.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps -ef | grep ds" and receive the following screen: Which process is a player?

A. 7217

B. 7215

C. 7117

D. 7216

Correct Answer: A

Question 7

A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)

A. Specify Multiple readers per node.

B. Set $APT_READ_MULTI_NODES to TRUE.

C. Set partitioning method to Same.

D. Ensure data has unique identifiers for data rows.

Correct Answer: A,D

Question 8

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 a new group of Product rows?

A. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".

B. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".

C. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

D. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

Correct Answer: A

Question 9

What two stages are required to place Header and Detail records, which have different formats, into a single format? (Choose two.)

A. Combine Stage

B. Funnel Stage

C. Column Import Stage

D. Column Export Stage

Correct Answer: B,D

Question 10

Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)

A. Web Service Function Definitions

B. Job Stage Column tab properties entered using "Load" feature

C. XML Table Definitions

D. Orchestrate Schema Definitions

E. Web Services WSDL Definitions

Correct Answer: A,C,E

Question 11

Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)

A. Establish a relationship between the key field column in the source stage with the database table field.

B. Sort the data on the reference link.

C. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

D. Change the lookup option in the stage properties to "Sparse".

Correct Answer: A,D

IBM InfoSphere DataStage v8.5 - C2090-421 Exam Practice Test

Latest Update

Useful Links

Contact Us