InfoSphere DataStage v8.5 (C2090-421) Free Practice Test

Question 1

In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.

Which two ways might be used to accomplish this without changing how the job functions? (Select two)

A. In the second Sort stage change the Sort Mode property of the state column to "Don't sort, previously sorted.".

B. In the second Sort stage change the Sort Mode property of the area column to "Don't sort, previously sorted.".

C. Remove the second Sort stage. Add area as an additional sort key.

D. Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.

Correct Answer: B,D

Question 2

How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

A. Use RCP definition wizard to initialize RCP for project use.

B. Set the APT_ENABLE_RCP environment variable to TRUE.

C. RCP is by default available for all DataStage Projects.

D. Use the DataStage Administrator to enable RCP for the project.

E. Use the Info Server web console to enable RCP

Correct Answer: D

Question 3

In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)

A. Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.

B. Avoid using the strings_025_and_026_in your IBM DB2 column names.

C. Avoid using the strings_035_and_036_in your IBM DB2 column names.

D. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.

Correct Answer: C,D

Question 4

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. Input columns must all be of the same data type.

B. Columns must be in consecutive order.

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

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

E. Input columns must form a numeric sequence.

Correct Answer: A,D,E

Question 5

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

A. Multiple-AMP requests are allowed.

B. Aggregates and most arithmetic operators in the SELECT statement 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: A

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

Question 6

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

A. text

B. record_length

C. intact

D. delim

E. record_delim_string

Correct Answer: B,C,E

Question 7

Which three of the following are valid schema formats? (Choose three.)

A. Integer Columns

B. Aggregator Columns

C. Raw Columns

D. Total Columns

E. Decimal Columns

Correct Answer: A,C,E

Question 8

Which three of the following are valid options for the dsjob command? (Choose three.)

A. Purging log files

B. Accessing log files

C. Setting an alias for a job

D. Stopping a job

E. Compiling a job

Correct Answer: B,C,D

Question 9

You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?

A. Select a Table Definition, then right click and choose Find where column is used. Select the column to search for from the list.

B. Open the Table Definition properties, Select the ADDRESS column, then right click and select Find where used.

C. From Designer Tools, open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.

D. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.

Correct Answer: D

Question 10

Which Information Server client application must be used to manage project-level roles for DataStage?

A. Director client

B. Web console for IBM Information Server

C. Designer client

D. WebSphere Information Services Director

Correct Answer: B

Question 11

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

A. Specify the remote server property.

B. Define columns for the output link.

C. Specify properties for the input link.

D. Define the connection properties to an ODBC data source.

Correct Answer: C,D

Welcome to TestSimulate

IBM InfoSphere DataStage v8.5 (C2090-421) Free Practice Test