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

出題：1

What conditions are necessary for a master record and an update record to merge?

A. none of the columns in the input record match the columns in the update record

B. all of the columns in the input record match the columns in the update record

C. some of the columns in the input record match the columns in the update record

D. both records have the same values for the merge key column(s) that you specify

正解：D 解答を投票する

出題：2

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. Compare Within

C. diffapicmdline.exe

D. DSMakeJobReport

正解：D 解答を投票する

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

出題：3

Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

A. Set $APT_DUMP_SCORE to true.

B. Use the DataStage Director Job administration screen to display active player processes.

C. Log onto the server and issue the command "ps -ef | grep ds".

D. Set $APT_PM_SHOW_PIDS to true.

正解：D 解答を投票する

出題：4

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 解答を投票する

出題：5

Which statement is true about buffering?

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

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

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

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

正解：A 解答を投票する

出題：6

The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

A. Aggregates and most arithmetic operators in the SELECT statement are allowed.

B. Multiple-AMP requests are allowed.

C. The use of the USING modifier is allowed.

D. Non-data access (e.g., pseudo-tables like DATE or USER) is allowed.

正解：B 解答を投票する

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

出題：7

You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables.You set environment variable $APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables. Which statement is accurate regarding the resulting effect of this environment variable setting?

A. Oracle load will run in parallel and bypass DataStage Director.

B. The Oracle load will run in parallel using simple direct path mode.

C. Oracle load will fail when executed.

D. The Oracle database stage will run in parallel using conventional path mode.

正解：C 解答を投票する

出題：8

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 メンバーにのみ表示されます)

出題：9

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

A. Use parameters to identify file names.

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

C. Generate unique file names by using a macro.

D. Use DSJobInvocationID to generate a unique filename.

正解：A 解答を投票する

出題：10

Which two statements are correct about XML stages and their usage? (Choose two.)

A. XML Input stage converts XML data to hierarchical format.

B. XML Output stage converts relational tables and sequential files to XML hierarchical structures.

C. XML Transformer stage converts an XML document to another XML hierarchical format.

D. XML Input stage transforms hierarchical XSLT data to tabular format.

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

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