A2090-421試験無料問題集（194題）「IBM Assessment: InfoSphere DataStage v8.5 認定」

出題：1

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

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

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 advanced properties tab, load the content or path of a stylesheet that is stored on the engine tier host.

正解：C,D 解答を投票する

出題：2

Which statement is true about the Web Services Pack?

A. Web Services Pack is configured from within the Information Services Director application.

B. Web Services Pack communicates by Enterprise Java Beans.

C. Web Services Pack generates a WSDL.

D. Web Services Pack makes a service request using SOAP.

正解：D 解答を投票する

出題：3

How is DataStage Table Metadata shared among DataStage projects?

A. DataStage Tables cannot be shared between projects.

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

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

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

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

正解：D 解答を投票する

出題：4

In a Transformer expression for a stage variable, there is a nullable input column. What happens when a row is processed that contains NULL in that input column?

A. NULL is written to the stage variable.

B. The value written to the stage variable is undetermined.

C. The row is rejected.

D. The job aborts.

正解：A 解答を投票する

出題：5

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.
What are two requirements on the input link data for the Change Capture stage? (Select two)

A. Key partitioned

B. Sorted

C. Merged links

D. Sequential mode

正解：C,D 解答を投票する

出題：6

Which two statements are correct when using the Oracle Enterprise stage? (Choose two.)

A. DataStage Designer requires connectivity to the Oracle database during job development.

B. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH.

C. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH, or $SHLIB_PATH.

D. Define variable $TNS_ADMIN to point to the tnsnames.ora file location.

正解：B,C 解答を投票する

出題：7

A job reads from a sequential file using a SequentialFile stage with option "number of readers" set to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet stage. The default configuration file has three nodes. The environment variable $APT_DISABLE_COMBINATION is set to "True" and partitioning is set to "Auto". How many processes will be created?

A. 9

B. 5

C. 12

D. 7

正解：A 解答を投票する

出題：8

Which requirement must be met to read from a database in parallel using the ODBC connector?

A. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

B. Configure environment variable $APT_PARTITION_COUNT.

C. ODBC connector always reads in parallel.

D. Set the Enable partitioning property to Yes.

正解：D 解答を投票する

出題：9

Which two statements are true about Transformer loop processing? (Select two)

A. Loop variable expressions are executed before output link column expressions.

B. Loop variable expressions are executed before stage variable expressions.

C. Stage variables can be referenced in loop conditions.

D. Loop conditions are evaluated once for each input row.

正解：B,D 解答を投票する

出題：10

You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic?

A. Create separate jobs and choose appropriate job within a job sequence.

B. Create parallel routines.

C. Create parallel shared containers and define columns combining all data formats.

D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic.

正解：D 解答を投票する

出題：11

You are setting up project defaults. Which three items can be set in DataStage Administrator? (Choose three.)

A. default prompting options, such as Autosave job before compile

B. default for compile options

C. default for Runtime Column Propagation

D. defaults for environment variables

E. suite roles

正解：B,C,D 解答を投票する

出題：12

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. Subrecord data type

B. Runtime Column Propagation

C. Schema File property

D. Vector data type

正解：A,B 解答を投票する

出題：13

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

C. 17

D. 12

正解：C 解答を投票する

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

出題：14

You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?

A. Open the Table Definition properties, Select the ADDRESS column, then right click and select Find where used.

B. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.

C. Select a Table Definition, then right click and choose Find where column is used. Select the column to search for from the list.

D. From Designer Tools, open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.

正解：B 解答を投票する

出題：15

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. Break the input file into multiple files.

B. Replace the Join with a Merge stage.

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

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

正解：D 解答を投票する

A2090-421試験無料問題集「IBM Assessment: InfoSphere DataStage v8.5 認定」