IBM InfoSphere DataStage v8.5 Set 1

Question - 15 Maximum mark : - 33

Home
All Exams
IBM InfoSphere DataStage v8.5 Online Practice Exams
IBM InfoSphere DataStage v8.5 Set 1

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 configuration file defined with three nodes. No environment variables were set for the job. How many osh processes will this job create?

8 ✘ 9 ✘ 11 ✘ 16 ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is true about the Web Services Pack?

Web Services Pack generates a WSDL. ✘ Web Services Pack makes a service request using SOAP. ✘ Web Services Pack communicates by Enterprise Java Beans. ✘ Web Services Pack is configured from within the Information Services Director application. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer wants to select the entire order details for the largest transaction for each of 2 million customers from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

Partition on customer key,sort on customer key and transaction amount,remove duplicates on customer
key. ✘ Use a Sort Aggregator stage with calculated column based on the maximum value of transactionamount column. ✘ Partition and sort the input to a Filter stage by customer number. Filter with the clause MAX(transaction_amount). ✘ Partition and sort the input to a RemoveDuplicates stage using the customer key and transactionamount columns. Remove duplicates on customer key. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Using a DB2 for z/OS source database, a 200 million row source table with 30 million distinct values must be aggregated to calculate the average value of two column attributes. What would provide optimal performance while satisfying the business requirements?

Select all source rows using a DB2 API stage. Aggregate using a Sort Aggregator. ✘ Using custom SQL with AVG functions and a DISTINCT clause,select all source rows using a DB2Enterprise stage. ✘ Using custom SQL with an ORDER BY clause based on key columns,select all source rows using theDB2 API stage. Aggregate using a Hash Aggregator. ✘ Select all source rows using a DB2 Enterprise stage,use a parallel Sort stage with the specified sortkeys,calculate the average values using a parallel Transformer with stage variables and output link constraints. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?

Specify restartable mode on a transfer of the single file. ✘ Manually split the file into multiple files and specify restartable mode on a transfer. ✘ Create multiple readers to transfer file data and specify restartable mode on Input link tab. ✘ Use a sequencer to check transfer status and restart the job from the beginning on failure. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A client needs to process a flat file where a set of values in the import data columns should be treated as Null. What is the best way to handle multiple Null values using a Sequential File stage?

On the Input Link format tab,specify the null values in double quotes separated by a comma in the Null
field value property. ✘ On the Output Link format tab,specify the null values in double quotes separated by a comma in the Nullfield value property. ✘ On the Input Link format tab,specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property. Click here to input option. ✘ On the Output Link format tab,specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

How does the Complex Flat File stage (CFF) support the use of OCCURS DEPENDING ON clause?

CFF does not support this clause. ✘ The related elements are output as arrays. ✘ The related elements are output as subrecords. ✘ The related elements are output as denormalized fields. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

How are Shared Table definitions created from the DataStage Client?

This cannot be done from the DataStage Client ✘ Using the Save button on the Table Properties panel ✘ Using the Save button on the columns tab on the Stage/Link editor ✘ Using the Shared Table Creation Wizard from the DataStage Client. ✔ No need to,DataStage table definitions are automatically saved as shared metadata. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Use the Info Server web console to enable RCP ✘ Set the APT_ENABLE_RCP environment variable to TRUE. ✘ RCP is by default available for all DataStage Projects. ✘ Use RCP definition wizard to initialize RCP for project use. ✔ Use the DataStage Administrator to enable RCP for the project. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which condition is required to use the LastRowInGroup() function to determine a key break on a field?

The LastRowInGroup() function requires the data to be grouped by the key field,but the data does not have to be sorted. ✘ The input data has to be sorted by the key field and DataStage must be able to detect that the data issorted,for example,by the presence of a Sort stage. ✘ The LastRowInGroup() function does not require the data to be either sorted or grouped by the key field.If necessary the LastRowInGroup() function will perform a sort. ✘ The input data has to be sorted by the key field,but it is not required that DataStage be able to detectthis. For example,the input data might be sorted before it is input to the job. (However,the job will abort
at runtime if the data isn't sorted.) ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM InfoSphere DataStage v8.5 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner