最新的IBM 000-421免費考試真題

問題1

You have a parallel shared container that is used by other parallel jobs within your project. Part of the logic in this shared container has been changed. Which two statements are true regarding this change to the parallel shared container? (Choose two.)

A. Jobs using this parallel shared container need to be re-compiled.

B. Use usage analysis and multi-compile to re-compile job using this shared container.

C. Jobs using this parallel shared container need to be re-compiled only when the metadata of the container is changed.

D. You can create a sequencer to re-compile all of the routines using this shared container.

正確答案: A,B

問題2

You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?

A. Set "Output mode" setting "Segregate" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.

B. Set "Output mode" setting "Break" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.

C. Set "Output mode" setting "Single row" under "Transformation Settings" of the Output link of an XML Output stage.

D. Set "Output mode" setting" Split rows" under "Transformation Settings" of the Output link of an XML Output stage.

正確答案: C

問題3

The result of a performance review for one of your job designs indicated this job needs to be split into two separate jobs. You also have been given the requirement to ensure you maintain parallelism (no re-partitioning) between these two new jobs.
Which single stage should you consider to accomplish maintaining parallelism and not introduce re-partitioning between these related jobs?

A. Copy stage

B. Sequential File stage

C. Named Pipe stage

D. Data Set stage

正確答案: B

說明：（僅 Fast2test 成員可見）

問題4

Your job design calls for using a target ODBC Connector stage. The target database is found on a remote server. The target table you are writing into contains a single column primary key. What are the three "Write mode" properties that allow the possibility of multiple SQL actions? (Choose three.)

A. Truncate then add

B. Insert then update

C. Update then insert

D. Delete then insert

E. Join then update

正確答案: B,C,D

問題5

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

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

B. The input data has to be sorted by the key field, but it is not required that DataStage be able to detect this. 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.)

C. The LastRowInGroup() function requires the data to be grouped by the key field, but the data does not have to be sorted.

D. The input data has to be sorted by the key field and DataStage must be able to detect that the data is sorted, for example, by the presence of a Sort stage.

正確答案: D

問題6

The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

A. Delete

B. Insert

C. Load

D. Update

正確答案: C

問題7

In the job fragment shown in the exhibit, the data going into the target Sequential File stage needs to be sorted by postal code. The Sort stage accomplishes this by running in Sequential mode and sorting by postal code. You have been asked to improve the performance of the job with a 4-node configuration file.

Which two changes will improve the performance of the job? (Choose two.)

A. Change the mode of the existing Sort stage to parallel mode; continue to sort by postal code. In the target Sequential File stage choose the SortMerge collector.

B. Move the Sort stage in front of the Filter stage, so that the sort is performed earlier in the job.

C. Add a second Sort stage just before the existing Sort stage; run the new stage in parallel mode sorting by postal code.

D. Eliminate the existing Sort stage; define an in-stage sort in the Filter stage, sorting by postal code. In the target Sequential File stage choose the SortMerge collector.

正確答案: A,D

問題8

Which two statements about annotations are correct? (Select two)

A. The Full job description field is only visible within the Designer Client.

B. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.

C. The Short job description field displays on log summary lines within Director client.

D. An annotation can be drawn around one of more stages.

正確答案: B,D

問題9

You have a DataStage job on SMP environment. It contains an input sequential file, a Modify stage, followed by a Transformer stage, and an output Sequential File stage. The job is run with three nodes. The engine uses all default settings. How many processes will this job create?

A. 9

B. 16

C. 19

D. 12

正確答案: A

問題10

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

A. Web Services WSDL Definitions

B. XML Table Definitions

C. Orchestrate Schema Definitions

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

E. Web Service Function Definitions

正確答案: A,B,E

問題11

A job design consists of an input SequentialFile stage, followed by a Peek stage, a Transformer stage, a Sort stage and finally an output Dataset stage. The job executes on an SMP system with a configuration file defined with 4 nodes.
The environment variable $APT_DISABLE_COMBINATION is set to "True". How many processes will this job create?

A. 21

B. 17

C. 19

D. 12

正確答案: B

說明：（僅 Fast2test 成員可見）

問題12

Which three statements are true about File Sets? (Choose three.)

A. File sets are partitioned.

B. File sets always execute in parallel.

C. File sets are stored as header file and data files.

D. File sets are readable by external applications.

E. File sets have a proprietary data format which may change in future DataStage versions.

正確答案: A,C,D

問題13

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

A. Manually break the file into multiple files by record type.

B. Define record definitions on the Constraints tab of the Complex Flat File stage.

C. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord.

D. Define record ID constraints on the Records ID tab of the Complex Flat File stage.

正確答案: D

問題14

In which two operations can you create DataStage projects? (Choose two.)

A. When adding new projects from DataStage Administrator.

B. When exporting and importing a DataStage project from DataStage Director.

C. During DataStage installation.

D. When creating a project in the IBM Information Server Console.

正確答案: A,C

最新的IBM InfoSphere DataStage v8.5 - 000-421免費考試真題

聯系我們

站內鏈接

最新更新