Latest IBM 000-421 Actual Free Exam Questions & Community Discussion, Page 4

Question #37

A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A. Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain.

B. Using the Dynamic Relational stage, use custom SQL to select all DISTINCT customer numbers from the order history table.

C. Select all rows using the ODBC Connector stage, use a Sort Aggregator on customer number key to select the maximum order date.

D. Using the DB2 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.

Discussion 0

Correct Answer: A Vote an answer

Question #38

When creating a Wrapper stage, which three tasks need to be done? (Select three)

A. Specify the command to be executed by the Wrapper.

B. Specify how Wrapper property values are to be converted.

C. Create Table Definitions that define the Wrapper's input and output columns.

D. Code and compile the C/C++ Wrapper source code.

E. Specify whether input rows are to be processed automatically or manually.

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #39

How is DataStage Table Metadata shared among DataStage projects?

A. Import another copy of the table metadata into the project where it is required.

B. Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.

C. Export DataStage Table Definitions from one project and importing them into another project.

D. Use the Import/Export Manager to move the DataStage Table Definition to the projects where it is needed.

E. DataStage Tables cannot be shared between projects.

Discussion 0

Correct Answer: B Vote an answer

Question #40

Which statement is true about buffering?

A. The "buffer" scratch disk pool needs to be defined to allow the framework to perform data buffering.

B. The framework uses /tmp by default for buffering on Unix systems.

C. The buffer operator uses both memory and disk storage.

D. In a clustered environment, using a disk space on an NFS mount for buffering improves performance.

Discussion 0

Correct Answer: C Vote an answer

Question #41

A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?

A. In a single job, use five separate FTP Enterprise stages with output links to a single Sort Funnel stage. Next, process the records without landing to disk.

B. Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next, process the records without landing to disk.

C. In a single job, use three separate FTP Enterprise stages (one for each machine) with output links to a single Sort Funnel stage. Next, process the records without landing to disk.

D. Create a sequence containing five separate DataStage jobs which each retrieve a single file and append it to a common Data Set. Next, process the resulting Data Set in an sixth DataStage job.

Discussion 0

Correct Answer: B Vote an answer

Question #42

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

A. The job aborts.

B. The input row is either dropped or rejected depending on whether the Transformer has a reject link.

C. NULL is written to the target stage variable.

D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.

Discussion 0

Correct Answer: C Vote an answer

Question #43

Which environment variable determines where the temporary scores are stored?

A. APT_HIGH_SCORE

B. APT_SAVE_SCORE

C. APT_DUMP_SCORE

D. APT_JOB_MON

Discussion 0

Correct Answer: B Vote an answer

Question #44

Which of the following describes what happens when Runtime Column Propagation is enabled?

A. An input column value flows into a target column only if it is explicitly mapped to it.

B. An input column value flows into a target column based on its position in a Schema file.

C. An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.

D. An input column value flows into a target column only if it matches it by name.

Discussion 0

Correct Answer: D Vote an answer

Question #45

A job validates credit card numbers with a reference file using a Join stage, which is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

A. Replace the Join with a Merge stage.

B. Alter the number of partitions in the $APT_CONFIG_FILE.

C. Use Round Robin partitioning on the stream and Entire partitioning on the reference.

D. Break the input file into multiple files.

Discussion 0

Correct Answer: B Vote an answer

Question #46

Which three attributes are found for each segment in a Data Set descriptor file? (Select three)

A. Schema of Data Set.

B. Path names of all data files on all processing nodes.

C. Statistical information such as number of records in the segment and number of bytes.

D. Flag marking segment as valid or invalid.

E. Copy of the configuration file used when segment was created.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #47

If you do not alter any of the Format settings, the Sequential File stage will produce a file with what three types of format? (Choose three.)

A. Rows are delimited by a UNIX newline.

B. All columns are delimited by a comma.

C. All columns are delimited by a comma, except for the final column in a row.

D. Rows are delimited by a DOS newline.

E. Variable length columns are contained within double quotes.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #48

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

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

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

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

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

Discussion 0

Correct Answer: B,D Vote an answer

IBM 000-421 Actual Free Exam Questions & Community Discussion

Download Free IBM 000-421 Demo