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

出題：1

Which three data types can the ODBC Enterprise stage handle? (Choose three.)

A. SQL_VARBINARY

B. SQL_BIGINT

C. SQL_CLOB

D. SQL_TIMESTAMP

E. SQL_SMALLDATETIME

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

出題：2

You are running a DataStage job using a 2-node configuration file. How can a fixed-width single sequential file be read in parallel? (Choose two.)

A. Set the "Read From Multiple Nodes" optional property to a value greater than 1.

B. Set the Execution Mode to the SequentialFile stage to "Parallel".

C. Set the "Number of Readers per Node" optional property to a value greater than 1.

D. Specify a node constraint for the SequentialFile stage.

E. Use an external Source stage.

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

出題：3

Which two partitioning methods require keys? (Choose two.)

A. Hash

B. Modulus

C. Entire

D. Round Robin

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

出題：4

External data conversions fall in two major types - automatic and manual. What are the three automatic conversions? (Select three)

A. Sequential File stage

B. Flat Text files

C. Relational data

D. SAS data

E. Modify operator

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

出題：5

A customer requests you to configure a Sequential File stage in a clustered environment. The stage must read a varying number of files each run in a single pass and append the name of the file the row was read from when an error occurs. What three steps are required to achieve this? (Select three)

A. Specify a file pattern option along with a file name mask that captures entire file list.

B. Set environment variable $APT_IMPORT_PATTERN_USES_FILESET.

C. Set environment variable $APT_SEQ_FILE_INCL_FILENAMES.

D. Specify multiple "File" properties.

E. Specify File Name Column property.

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

出題：6

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

A. Aggregator Columns

B. Integer Columns

C. Raw Columns

D. Decimal Columns

E. Total Columns

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

出題：7

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

出題：8

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

出題：9

The purchase history record contains CustID, ProductID, ProductType and TotalAmount. You need to retain the record of greatest TotalAmount per CustID and ProductType using RemoveDuplicate stage. Which two statements accomplish this requirement? (Choose two.)

A. Hash-partition on CustID and ProductType;
Sort on CustID, ProductType and TotalAmount.

B. Hash-partition on CustID, ProductType and TotalAmount;
Sort on CustID, ProductType and TotalAmount.

C. Hash-partition on ProductType;
Sort on ProductType, CustID and TotalAmount.

D. Hash-partition on CustID;
Sort on CustID, ProductType and TotalAmount.

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

出題：10

You are setting up the parallel engine configuration file. Which two statements are true about file system efficiency? (Select two)

A. Using multiple scratch spaces in a logical node improves performance.

B. Specify a directory for the resource disk in the partition where the engine is installed.

C. In a clustered environment where NAS is used for a common storage, specify the internal disk for scratch disk.

D. Creating scratch disk space on an internal disk improves sort performance than NFS drive.

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

出題：11

You are responsible for managing job changes for you project team. You must update the source code repository through Eclipse Team source code integration whenever a developer notifies you of an asset change.
What two tasks allow you to update the source code repository with the changed asset? (Select two)

A. Right-click the asset and click the Build command

B. Right-click the asset and click the Deploy command

C. Right-click the asset and click the Send to Source Control Work Space.

D. Right-click the asset and click the Team command to commit the artifact to the source control system.

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

出題：12

Which of the following is not an ODBC connector property?

A. Data source

B. Password

C. Remote server

D. Username

正解：C 解答を投票する

出題：13

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

出題：14

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

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

B. Schema of Data Set.

C. Flag marking segment as valid or invalid.

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

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

正解：A,D,E 解答を投票する

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