000-303 Exam Training Practice Tests (IBM Certified Solution Developer

Question 1

Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

A. Use a Transformer stage variable to generate the name. B. Use DSJoblnvocationID to generate a unique filename. C. Use parameters to identify file names. D. Generate unique file names by using a macro.

Correct Answer: C

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

Question 2

Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

A. It includes the XML Input, XML Output, and XML Transformer stages. B. Uses a unique custom GUI interface called the Assembly Editor. C. A single XML Stage, which can be used as a source, target, or transformation. D. XML Stages are Plug-in stages. E. XML Stage can be found in the Database folder on the palette.

Correct Answer: B,C

Question 3

How must the input data set be organized for input into the Join stage? (Choose two.)

A. Key partitioned B. Hash partitioned C. Unsorted D. Sorted by Join key E. Entire partitioned

Correct Answer: A,D

Question 4

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 support this job design change. What two characteristics of Data Sets make them a good design consideration in your jobs design change? (Choose two.)

A. They persist the parallelism of the job creating them. B. They persist parallelism into a temporary repository table. C. They automatically convert data types. D. They use the same data types as the parallel framework. E. They sort the data in a staging area.

Correct Answer: A,D

Question 5

What role must a user have to delete shared metadata assets from the repository?

A. DataStage Administrator B. Common Metadata Administrator C. Business Glossary Administrator D. Information Analyzer Administrator

Correct Answer: B

Question 6

In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option is turned off. What happens when a row is processed that contains NULL in that input column?

A. The job aborts. B. The row is rejected. C. The value written to the stage variable is undetermined. D. NULL is written to the stage variable.

Correct Answer: D

Question 7

Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

A. Wrapped stage B. Basic stage C. Group stage D. Input stage E. Custom stage

Correct Answer: A,E

IBM Certified Solution Developer - IBM InfoSphere DataStage - 000-303 Exam Practice Test