最新なIBM C2090-424問題集（64題）、真実試験の問題を全部にカバー！

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

質問 2：
How do you create a shared table definition from the DataStage client?
A. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.
B. Use the shared table creation wizard from the repository window
C. Do nothing. They are created automatically when table definitions are imported
D. Use the save button on the columns tab of the stage editor
正解：B

質問 3：
A Parameter Set is a named object that can contain which of the following?
A. Only one parameter and only one value file
B. Multiple parameters and multiple value files
C. Multiple parameters and only one value file
D. Only one parameter and multiple value files
正解：D

質問 4：
In order to use Cognos TM1 Connector, which statement is TRUE?
A. Install the Cognos TM1 API component and create a property file that stores truststore password
B. Import the IBM Cognos TM1 certificate and create a property file that stores truststore password
C. Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password
D. Installing the Cognos TM1 API component alone is sufficient.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?
A. Change Capture
B. Difference
C. Change Capture and Change Apply
D. Change Apply
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
Which statement is TRUE about Balanced Optimization?
A. Balanced optimizations are performed in a priority order. When there is ambiguity (for example, some processing could be performed either in a source or target database) processing is pushed into database sources.
B. Balanced Optimization will change or optimize machine configurations, InfoSphere DataStage configurations, database configurations, or HDFS configurations.
C. Balanced Optimization creates a parameter set called BalOpJAQLParams in the underlying project if it does not exist.
D. Balanced Optimization is installed with InfoSphere DataStage.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
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