000-421問題集、IBM実際の試験問題

質問 1

How are Shared Table definitions created from the DataStage Client?

A. Using the "Shared Table Creation Wizard" from the DataStage Client.

B. Using the "Save" button on the "Table Properties" panel

C. No need to, DataStage table definitions are automatically saved as shared metadata.

D. This cannot be done from the DataStage Client

E. Using the "Save" button on the columns tab on the Stage/Link editor

正解: A

質問 2

Which three of the following are valid schema formats? (Choose three.)

A. Integer Columns

B. Decimal Columns

C. Raw Columns

D. Total Columns

E. Aggregator Columns

正解: A,B,C

質問 3

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What two options will allow jobs with a parallel transformer to execute in the customers production machines? (Choose two.)

A. Create a package with Information Server Manager and select the option to include executables.

B. Add $APT_COMPILE_OPT=-portable

C. Set $APT_COPY_TRANSFORM_OPERATOR

D. Export the jobs with Information Server Manager with the executables.

正解: A,D

質問 4

What are two ways to specify a stylesheet in an XML input stage? (Choose two.)

A. On the output link advanced properties tab, load the content or path of a stylesheet that is stored on the engine tier host.

B. On the output link columns properties tab, type the stylesheet in the XLST box.

C. On the output link advanced properties tab, type the stylesheet in the Stylesheet box.

D. On the output link columns properties tab, identify an input column that contains the stylesheet URL.

正解: A,C

質問 5

What two features enable a job with a Sequential File stage to read from sequential files with different numbers of columns and types? (Select two)

A. Schema File property

B. Runtime Column Propagation

C. Subrecord data type

D. Vector data type

正解: B,C

質問 6

In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)

A. Avoid using the strings_035_and_036_in your IBM DB2 column names.

B. Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.

C. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.

D. Avoid using the strings_025_and_026_in your IBM DB2 column names.

正解: A,C

質問 7

When using Runtime Column Propagation, which three stages require a schema file? (Select three)

A. DB2 Enterprise stage

B. Sequential File stage

C. Column Import stage

D. Peek stage

E. File Set stage

正解: B,C,E

解説: (PassTest メンバーにのみ表示されます)

質問 8

You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which three techniques will enable you to retrieve the sum of the last group? (Choose three.)

A. Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.

B. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.

C. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.

D. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.

E. Output the sum that you generated each time you process a row for which the LastRow() function returns True.

正解: A,B,D

質問 9

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

A. Generate unique file names by using a macro.

B. Use a Transformer stage variable to generate the name.

C. Use parameters to identify file names.

D. Use DSJobInvocationID to generate a unique filename.

正解: C

質問 10

Which three of the following options does the dsjob command have? (Choose three.)

A. Stopping a job

B. Setting an alias for a job

C. Specifying an appropriate log file

D. Listing projects, jobs, stages, links, and parameters

正解: A,B,D

質問 11

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

B. 9

C. 16

D. 12

正解: B

質問 12

What is the correct restructure stage to extract data from four input columns (three of which carry vectors) and output them into two columns with one vectors in a subrecord and the non-vector carrying column being passed through the stage?

A. Column Export Stage

B. Column Import Stage

C. Make Subrecord Stage

D. Split Subrecord Stage

正解: B

質問 13

Which three DataStage elements allow you to create Shared MetaData? (Select three)

A. Dataset stage

B. DB2 Connector

C. Oracle Connector

D. DataStage table definition

E. Sequential file stage

正解: A,B,D

質問 14

A copy of a production job was moved into a development project and modified to improve performance. You must prepare a report for a code review that documents the changes to the job.
How would you gather the information for this report? (Select two)

A. Cross Project Compare

B. DSMakeJobReport

C. diffapicmdline.exe

D. Compare Within

正解: B

解説: (PassTest メンバーにのみ表示されます)

IBM InfoSphere DataStage v8.5 - 000-421 模擬練習