C2090-424 Online Practice Questions and Answers
What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?
A. Data rules cannot be created within the Data Rules stage. They must first be created in Information Analyzer before they can be used in the Data Rules stage.
B. Rules created within Information Analyzer can be tested and debugged on non-operational data in a testing environment before they are put into production.
C. Rules created in the DataStage Data Rules stage have to be compiled into an executable form before they can be used.
D. The variables in rules created in DataStage Data Rules stage must first be bound to data columns or literals before they can be run.
Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)
A. Data Set
B. Column Import
C. Internal Source
D. External Target
E. Make Subrecord
Which one of the following is an implicit data type conversion?
A. date -> char
B. char -> date
C. varchar -> char
D. char -> timestamp
To run multiple copies of the same job within Director, which of the following must be supplied?
A. Job name
B. Invocation ID
C. Parameter values
D. Username and password
In order to use Cognos TM1 Connector, which statement is TRUE?
A. Installing the Cognos TM1 API component alone is sufficient.
B. Import the IBM Cognos TM1 certificate and create a property file that stores truststore password
C. Install the Cognos TM1 API component and create a property file that stores truststore password
D. Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password
Which Slowly Changing Dimension (SCD) stage statement is TRUE?
A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database
B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching
C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.
D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link
The APT_SubProcessOperator is used for what purpose?
A. It allows you to incorporate a third-party executable into the framework
B. It provides the capability to break predefined operators into sub processes
C. It provides the capability to define custom operators at the sub process level
D. It allows you to incorporate composite operators, which contain more than one operator
Which Connector Stage doesn't support reject Link
A. DB2 Connector
B. ODBC Connector
C. Oracle Connector
D. Netezza Connector
Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.
A. iisAdmin.sh –user srv_etl –password Info1234
B. iisAdmin.sh –user –userid srv_etl –password Info1234
C. SessionAdmin.sh –user –userid srv_etl –password Info1234
D. DirectoryAdmin.sh –user –userid srv_etl –password Info1234