C2090-424 Online Practice Questions and Answers

Which of the following is NOT TRUE about the DataStage job score?

A. It includes the operators automatically inserted at runtime

B. It helps to determine the number of actual operating system processes

C. It reports the amount of memory used by the inter-operator transport buffers

D. It outlines the connection topology between adjacent operators and persistent data sets

Which statement about looping in sequences is TRUE?

A. The Start Loop stage only supports numeric loops

B. Numeric loops must increment by one unless you supply a parameter

C. The current loop counter value can be passed to the stages in the loop

D. The compiler will insert an End Loop as the last stage in the sequence if one is omitted

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

A. Predicates cannot refine what rows are updated

B. Table(s) referenced must have table definitions imported previously

C. Column values can be job parameters or input columns but not expressions

D. Columns to update must be selected individually from the column selection grid

Record Count property is set to zero in Connector stage. How many rows are written out?

A. All Rows

B. One Row

C. Zero Rows

D. 2000 Rows

Which of the following is the correct schema format for a Time column?

A. record (tField:time[hour:minute:second];)

B. record (tField:nullable time[];)

C. record (tField:time[seconds];)

D. record (tField:time[microseconds];)

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

Which of the following is NOT a valid use of stage variables?

A. Storing values to be used in both derivations and constraints

B. Storing values that can be referenced by name in downstream stages

C. Storing values from one row to compare with values in the next row read

D. Storing the result on an expression to be used in multiple output columns

Which one of the following stages requires a schema file when using Runtime Column Propagation?

A. Modify Stage

B. Data Set Stage

C. Transformer Stage

D. Sequential File Stage

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