pass4sure ibm 000-415

IBM WebSphere IIS DataStage Enterprise Edition v7.5 : 000-415 Exam
Exam Topics Include:
• Installation and Configuration
• Metadata
• Persistent Storage
• Parallel Architecture
• Databases
• Data Transformation
• Combining and Sorting Data
• Automation and Production Deployment
• Monitoring and Troubleshooting
• Job Design
Product Description

Exam Number/Code: 000-415

Exam Name:IBM WebSphere IIS DataStage Enterprise Edition v7.5

“IBM WebSphere IIS DataStage Enterprise Edition v7.5″, also known as 000-415 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 158 questions to your 000-415 Exam preparation. In the 000-415 exam resources, you will cover every field and category in IBM certifications helping to ready you for your successful IBM Certification.

Exam Details

The IBM Certified Solution Developer – WebSphere IIS DataStage Enterprise Edition v7.5 has the critical knowledge and skills necessary to professionally design and develop an efficient and scalable DataStage EE solution to a complex enterprise level business problem; configure a scalable parallel environment including clustered and distributed configurations; collect, report on, and resolve issues identified through key application performance indicators; be proficient in extending the capabilities of the parallel framework using the provided APIs (buildops, wrappers, and components). The qualified individual can design and develop a scalable complex solution using a minimum number of components, can precisely control data partitioning and provide for minimum data skew. This individual should also be able to configure a distributed or non-symmetric environment and should be able to tune a parallel application to determine where bottlenecks exist and how to eliminate them. The certified individual can work with complex data import and export scenarios (arrays, structures, tagged, packed, binary data, etc.) and understands the intricacies of designing parallel solutions without relying on automated insertion of partitioning and sort operations. The candidate clearly understands what an inserted buffer operation is, can enable environment variables to collect performance statistics and can determine the appropriate response to the collected data. To attain the IBM Certified Solution Developer – WebSphere IIS DataStage Enterprise Edition v7.5 certification, candidates must pass 1 test (Test 415: IBM WebSphere IIS DataStage Enterprise Edition v7.5).

QUESTION 1
Which three stages support the dynamic (runtime) definition of the physical column metadata? (Choose three.)

A. the Sequential stage
B. the Column Export stage
C. the CFF stage
D. the DRS stage
E. the Column Import stage

Answer: A,B,E

QUESTION 2
A Varchar(10) field named SourceColumn is mapped to a Char(25) field named TargetColumn in a Transformer stage. The APT_STRING_PADCHAR environment variable is set in Administrator to its default value. Which technique describes how to write the derivation so that values in SourceColumn are padded with spaces in TargetColumn?

A. Include APT_STRING_PADCHAR in your job as a job parameter. Specify the C/C++
end of string character (0×0) as its value.
B. Map SourceColumn to TargetColumn. The Transformer stage will automatically pad with spaces.
C. Include APT_STRING_PADCHAR in your job as a job parameter. Specify a space as
its value.
D. Concatenate a string of 25 spaces to SourceColumn in the derivation for
TargetColumn. Answer: C
QUESTION 3
Which three privileges must the user possess when running a parallel job? (Choose three.)

A. read access to APT_ORCHHOME
B. execute permissions on local copies of programs and scripts
C. read/write permissions to the UNIX/etc directory
D. read/write permissions to APT_ORCHHOME
E. read/write access to disk and scratch disk resources

Answer: A,B,E

QUESTION 4
In a Teradata environment, which stage invokes Teradata supplied utilities?

A. Teradata API
B. DRS Teradata
C. Teradata Enterprise
D. Teradata Multiload

Answer: D

QUESTION 5
When importing a COBOL file definition, which two are required? (Choose two.)

A. The file you are importing is accessible from your client workstation. B. The file you are importing contains level 01 items.
C. The column definitions are in a COBOL copybook file and not, for example, in a
COBOL source file.
D. The file does not contain any OCCURS DEPENDING ON clauses. Answer: A,B
QUESTION 6
Which two tasks will create DataStage projects? (Choose two.)

A. Export and import a DataStage project from DataStage Manager. B. Add new projects from DataStage Administrator.
C. Install the DataStage engine.
D. Copy a project in DataStage Administrator. Answer: B,C
QUESTION 7
Which three defaults are set in DataStage Administrator? (Choose three.)

A. default prompting options, such as Autosave job before compile
B. default SMTP mail server name
C. project level default for Runtime Column Propagation
D. project level defaults for environment variables
E. project level default for Auto-purge of job log entries

Answer: C,D,E

QUESTION 8
Which three are keyless partitioning methods? (Choose three.)

A. Entire
B. Modulus
C. Round Robin
D. Random

E. Hash

Answer: A,C,D

QUESTION 9
Which two must be specified to manage Runtime Column Propagation? (Choose two.)

A. enabled in DataStage Administrator
B. attached to a table definition in DataStage Manager
C. enabled at the stage level
D. enabled with environmental parameters set at runtime

Answer: A,C

QUESTION 10
Which three are valid ways within a Job Sequence to pass parameters to Activity stages?
(Choose three.)

A. ExecCommand Activity stage B. UserVariables Activity stage C. Sequencer Activity stage
D. Routine Activity stage
E. Nested Condition Activity stage

Answer: A,B,D

QUESTION 11
A client requires that a database table be done using two jobs. The first job writes to a dataset. The second job reads the dataset and loads the table. The two jobs are connected
in a Job Sequence. What are three benefits of this approach? (Choose three.)

A. The time it takes to load the table is reduced.
B. The database table can be reloaded after a failure without re-reading the source data.
C. The dataset can be used by other jobs even if the database load fails. D. The dataset can be read if the database is not available.
E. The data in the dataset can be archived and shared with other external applications. Answer: B,C,D
QUESTION 12
You are reading customer data using a Sequential File stage and transforming it using the Transformer stage. The Transformer is used to cleanse the data by trimming spaces from character fields in the input. The cleansed data is to be written to a target DB2 table.
Which partitioning method would yield optimal performance without violating the business requirements?

A. Hash on the customer ID field
B. Round Robin
C. Random
D. Entire

Answer: B

QUESTION 13
Which three are valid trigger expressions in a stage in a Job Sequence? (Choose three.)

A. Equality(Conditional) B. Unconditional
C. ReturnValue(Conditional) D. Difference(Conditional)
E. Custom(Conditional) Answer: B,C,E
QUESTION 14
An Aggregator stage using a Hash technique processes a very large number of rows
during month end processing. The job occasionally aborts during these large runs with an obscure memory error. When the job is rerun, processing the data in smaller amounts corrects the problem. Which change would correct the problem?

A. Set the Combinability option on the Stage Advanced tab to Combinable allowing the
Aggregator to use the memory associated with other operators. B. Change the partitioning keys to produce more data partitions.
C. Add a Sort stage prior to the Aggregator and change to a sort technique on the Stage
Properties tab of the Aggregator stage.
D. Set the environment variable APT_AGG_MAXMEMORY to a larger value. Answer: C
QUESTION 15
Which three actions are performed using stage variables in a parallel Transformer stage?
(Choose three.)

A. A function can be executed once per record. B. A function can be executed once per run.
C. Identify the first row of an input group. D. Identify the last row of an input group.
E. Lookup up a value from a reference dataset. Answer: A,B,C

*pass4sure ibm 000-415 Questions and Answers : 158 questions
* Updated: October 2nd , 2008
* Price: $159.99 $99.99

Free down:Testking ibm 000-415
Free down:Pass4sure ibm 000-415

IBM Free Downloads

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
	All Ibm 's Exam Pack	767	1 days ago	Download

Random Posts

• passguide lot-755
• passguide 000-217
• passguide 000-m25
• passguide 000-142
• 000-m31
• Actualtests ibm 000-641
• 000-M41
• LOT-959
• Pass4sure ibm 000-870
• Actualtests ibm 000-867
• Pass4sure ibm 000-990
• 000-021
• Actualtests ibm 000-010
• passguide 000-527
• pass4sure ibm On Demand Business: On Demand Business