1149 お客様のコメント
質問 1：
Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)
A. Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property.
B. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
C. Provide a specific file name in the file name property.
D. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1.
E. In the file name property, provide a file name with a wildcard that matches the existing file names.
正解：B,D
質問 2：
Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
Push processing to data sources
Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
Push data reduction processing to data targets
Push all processing into the (target) data server
Assuming the job design allows for maximum optimization, what does the optimized job design look like?
A. DB2 Connector stage followed by a DB2 Connector stage
B. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage
C. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage
D. Row Generator stage followed by a DB2 Connector stage
正解：D
質問 3：
Which Slowly Changing Dimension (SCD) stage statement is TRUE?
A. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link
B. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database
C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.
D. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.
What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)
A. Change properties in the Aggregator stage to force it to use the new non-default configuration file
B. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated
C. Select the "highperfnodes" pool in the Execution tab of the Job Properties window
D. Add the $APT_CONFIG_FILE environment variable as an additional job parameter
E. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool
正解：C,E
質問 5：
Which of the following is NOT TRUE about the DataStage job score?
A. It outlines the connection topology between adjacent operators and persistent data sets
B. It reports the amount of memory used by the inter-operator transport buffers
C. It includes the operators automatically inserted at runtime
D. It helps to determine the number of actual operating system processes
正解：D
質問 6：
Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)
A. Internal Source
B. Data Set
C. Column Import
D. External Target
E. Make Subrecord
正解：C,D
解説: (Pass4Test メンバーにのみ表示されます)
Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)
A. Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property.
B. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
C. Provide a specific file name in the file name property.
D. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1.
E. In the file name property, provide a file name with a wildcard that matches the existing file names.
正解：B,D
質問 2：
Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
Push processing to data sources
Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
Push data reduction processing to data targets
Push all processing into the (target) data server
Assuming the job design allows for maximum optimization, what does the optimized job design look like?
A. DB2 Connector stage followed by a DB2 Connector stage
B. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage
C. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage
D. Row Generator stage followed by a DB2 Connector stage
正解：D
質問 3：
Which Slowly Changing Dimension (SCD) stage statement is TRUE?
A. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link
B. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database
C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.
D. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 4：
Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.
What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)
A. Change properties in the Aggregator stage to force it to use the new non-default configuration file
B. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated
C. Select the "highperfnodes" pool in the Execution tab of the Job Properties window
D. Add the $APT_CONFIG_FILE environment variable as an additional job parameter
E. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool
正解：C,E
質問 5：
Which of the following is NOT TRUE about the DataStage job score?
A. It outlines the connection topology between adjacent operators and persistent data sets
B. It reports the amount of memory used by the inter-operator transport buffers
C. It includes the operators automatically inserted at runtime
D. It helps to determine the number of actual operating system processes
正解：D
質問 6：
Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)
A. Internal Source
B. Data Set
C. Column Import
D. External Target
E. Make Subrecord
正解：C,D
解説: (Pass4Test メンバーにのみ表示されます)
斉藤** -
C2090-424試験のテキストですが、これが実に解り易い。図が多く、イメージをつかみやすい