Free and Premium IBM P2090-045 Dumps Questions Answers

You CANNOT create a logical model from a physical model

InfoSphere Data Architect can deploy physical data models directly to the database management system

Reverse engineering data models only works for DB2 databases

InfoSphere Data Architect is installed using the Information Server installation wizard

DataStage Administrator client only

DataStage Administrator or Director client

DataStage Director client only

DataStage Designer or Director client.

Deletes rows from a DB2 table

Reads a DB2 table

Automatically updates table definitions when a SQL type mismatch is detected

Performs a lookup directly on a DB2 table

Automate data relationship discovery

Prototype a data model for the first time

Automate transformation rule discovery

Automate business object identification

All of the above

Information Server Web Console

DataStage Administrator

DataStage Director

DataStage Designer

If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results

ROUND ROBIN ensures correct results

Information Server metadata repository

In the file system as a binary file

In the file system as a csv file

None of the above

TXT and XML

DSX and CSV

DSX and XML

TXT and CSV