Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)
A. Input stage
B. Group stage
C. Basic stage
D. Custom stage
E. Wrapped stage
正解:D,E
質問 2:
Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?
A. Sort the data on the reference link.
B. Change the partitioning to hash.
C. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
D. Change the lookup option in the stage properties to "Sparse".
正解:D
質問 3:
Which two statements are true about Data Sets? (Choose two.)
A. Data Sets preserve partitioning.
B. Data Sets represent persistent data.
C. Data Sets require import/export conversions.
D. Data Sets require repartitioning.
E. Data sets contain ASCII data.
正解:A,B
質問 4:
Which method is used to specify when to stop a job because of too many rejected rows with an ODBC Connector?
A. In the Abort when field, select Max
B. In the Abort when field, select Amount
C. In the Abort when field, select Rows
D. In the Abort when field, select Count
正解:C
質問 5:
In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)
A. DataStage server system name
B. Database instance
C. Database
D. Project name
E. Host system
正解:C,E
質問 6:
What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)
A. SFTP
B. TFTP
C. RFTP
D. FTP
E. EFTP
正解:A,D
質問 7:
Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?
A. XML to SQL_WVARCHAR
B. CHAR FOR BIT DATA to SQL_VARBINARY
C. BIGINT to SQL_BIGINT (INT32)
D. VARCHAR, 32768 to SQL_VARCHAR
正解:A
質問 8:
How must the input data set be organized for input into the Join stage? (Choose two.)
A. Key partitioned
B. Sorted by Join key
C. Hash partitioned
D. Entire partitioned
E. Unsorted
正解:A,B
質問 9:
Which Oracle data type conversion is correct?
A. Oracle data type NUMBER(15,0) converts to INT32 in Oracle Connector stage.
B. Oracle data type NUMBER converts to DECIMAL(38,0) in Oracle Connector stage.
C. Oracle data type RAW converts to RAW in Oracle Connector stage.
D. Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.
正解:D
Kamiya -
C2090-303使いやすかった。ここで感謝を申し上げます。ありがとうございました。