最新的IBM C2090-418免費考試真題

問題1

In which two situations would you use the Web Services Client stage? (Choose two.)

A. You do not need both input and output links in a single web service operation.

B. You need to create a WSDL.

C. You need the Web service to act as either a data source or a data target during an operation.

D. You want to deploy a service.

正確答案: A,C

問題2

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 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.

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

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

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

正確答案: B

問題3

Which stage does not require sorted input?

A. Lookup stage

B. Join stage

C. Remove Duplicates stage

D. Merge stage

正確答案: A

問題4

Click the Exhibit button.
In the exhibit, a Funnel stage has two Input Links. Input 1(Seq_File) comes from a sequential file with set "Readers per Node" set to "2" , Input 2(Dataset) comes from a Data Set created in parallel (three-way parallel). Within the Funnel stage, the funnel type is set to "Sequence". The parallel configuration file contains three nodes. How many instances of the Funnel stage run in parallel?

A. 3

B. 2

C. 1

D. 6

正確答案: A

問題5

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

A. Specify the partitioncol property.

B. Configure environment variable $APT_PARTITION_COUNT.

C. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

D. ODBC Enterprise stage always reads in parallel.

正確答案: A

問題6

Which import option can be used to import metadata from a data modeling tool such as Erwin or Rational Data Architect?

A. Import a table definition using the Connector wizard.

B. Import using bridges.

C. Import DataStage components.

D. Import a table definition using the Plug-In Meta Data facility.

正確答案: B

問題7

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? (Choose two.)

A. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.

B. Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.

C. Avoid using the strings __025__ and __026__ in your IBM DB2 column names.

D. Avoid using the strings __035__ and __036__ in your IBM DB2 column names.

正確答案: A,D

問題8

Click the Exhibit button.
In the exhibit, how many parallel partitions will each DataStage operator run without specifying a "node pool and resource constraint" or actual "node constraint"?

A. four

B. three

C. one

D. two

正確答案: B

最新的IBM Websphere Datastage V.8.0 - C2090-418免費考試真題

聯系我們

站內鏈接

最新更新