Online Access Free P2090-046 Exam Questions

Which of the following is a valid Write Mode action in the Connector Stages?

• A.Insert
• B.Delete
• C.Update
• D.All of the above

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

• A.NULL is written to the target stage variable.
• B.The input row is either dropped or rejected depending on whether the Transformer has a reject link.
• C.The target stage variable is populated with spaces or zeros depending on the stage variable data type.
• D.The job aborts.

Which of the following statements about InfoSphere Data Architect is correct?

• A.InfoSphere Data Architect can deploy physical data models directly to the database management system
• B.InfoSphere Data Architect is installed using the Information Server installation wizard
• C.You CANNOT create a logical model from a physical model
• D.Reverse engineering data models only works for DB2 databases

Which of the following CANNOT be defined in the DataStage configuration file?

• A.Degree of parallelism
• B.A named pool including only part (some) of the nodes
• C.Scratch disk dedicated for sorting
• D.Compilation options for DataStage jobs

Which of the following statements about partitioning algorithms is correct?

• A.SAME partitioning method is the fastest algorithm because it does not require additional processing
• B.The grouping methods available in the Aggregator stage are MODULUS and HASH
• C.MODULUS and HASH ensure balanced data volumes in all the partitions
• D.For the Lookup reference stage, DataStage always uses the MODULUS method