IBM C2090-303 問題集

質問 1：
Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)
A. Split Subrecord
B. Column Import
C. Merge records
D. Split Vector
E. Make Subrecord
正解：A,E

質問 2：
The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are two change values identified by these code values? (Choose two.)
A. Deleted
B. Final
C. Copy
D. Remove Duplicates
E. Edit
正解：A,C

質問 3：
Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)
A. The default for requestedsessions is the maximum number of available sessions.
B. Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.
C. Sessionsperplayer determines the number of connections each player in the job has to Teradata.
D. The default for requestedsessions is the minimum number of available sessions.
E. Requestedsessions is a number between 1 and the number of vprocs in the operating system.
正解：A,C

質問 4：
When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What message handler level is available?
A. stage level
B. parameter level
C. record level
D. project level
正解：D

質問 5：
The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links,expanding the icon border can significantly improve readability. This approach takes extra effort at first, so a pattern of work needs to be identified and adopted to help development. Which feature of Designer can improve development speed?
A. Repository Layout
B. Snap to Grid Feature
C. Show Performance Statistics Feature
D. Palette Layout
正解：B

質問 6：
Identify two items that are created as a result of running a Balanced Optimization on a job that accesses a Hadoop distributed file system as a source? (Choose two.)
A. A MapReduce Transformer stage is found in the optimized job result.
B. A Balanced Optimization Shared Container is found in the project.
C. A Balanced Optimization parameter set is found in the project
D. A Big Data File stage is found in the optimized job results.
E. A JAQL stage is found in the optimized job result.
正解：C,E

質問 7：
In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?
A. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.
B. Create parallel shared containers and define columns combining all data formats.
C. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.
D. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.
正解：C

質問 8：
A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring 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. Replace the Join with a Merge stage.
B. Change the number of nodes in the configuration file.
C. Add a Sort stage in front of the Join stage. Sort by account number.
D. Use Round Robin partitioning on the stream and Entire partitioning on the reference.
正解：B

質問 9：
Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)
A. Uses a unique custom GUI interface called the Assembly Editor.
B. XML Stage can be found in the Database folder on the palette.
C. XML Stages are Plug-in stages.
D. A single XML Stage, which can be used as a source, target, or transformation.
E. It includes the XML Input, XML Output, and XML Transformer stages.
正解：A,D