P2090-011 Online Practice Questions and Answers

Which of the following database objects can be replicated while integrating heterogeneous data sources?

A. Tables and Stored Procedures

B. Tables and Tablespaces

C. Tables and Views

D. Table objects only

Which additional step may be needed to configure bi-directional replication?

A. specify 'Conflict Detection' rules

B. specify Primary Key

C. specify a Unique Index

D. restart the CDC source instance

Which of the following connection methods is used to integrate CDC with InfoSphere DataStage?

A. Flat File, Staging Tables, Direct Connect and Shared Memory

B. Flat File, Staging Tables, Direct Connect and Messaging Queue

C. Flat File, Staging Tables, Direct Connect and Named Pipes

D. All of the above.

What happens when the DataStage job which is receiving updates from CDC is terminated by the DataStage user?

A. CDC subscription waits until the DataStage job is restarted

B. CDC subscription feeding to DataStage fails with an error

C. CDC subscription feeding to DataStage terminates automatically

D. CDC datastore connecting to DataStage disconnects automatically

Which of the following sets of replication modes is supported in CDC?

A. Refresh, Net Change, Periodic

B. Refresh, Continuous, Real-Time

C. Refresh, Net Change, Continuous

D. Log Based, Event Based, Trigger Based

Which additional step is required to configure bi-directional replication?

A. check the 'Prevent Recursion' box

B. specify Primary Key

C. specify a Unique Index

D. restart the CDC source instance

The Monitoring tab in Management Console allows users to ________________.

A. view Subscription Status, Replication Statistics, and Event Logs

B. display Latency and Replication Diagrams

C. setup Alerts and Notifications

D. All of the above.

Can CDC be a part of the solution to migrate a customer environment from one hardware system to another?

A. CDC can be used to migrate both the Data and Application environments.

B. CDC can be used to migrate only the Data environment.

C. CDC can be used to migrate only the Application environment.

D. CDC can not help in migrating a customer environment between two hardware systems.

Which of the following will be a valid SOURCE for "InfoSphere Change Data Capture for Oracle Replication"?

A. Oracle database running on any supported platform

B. Oracle database running on Windows platform only

C. Any heterogeneous data source running on any supported hardware platform

D. Any heterogeneous data source running on Windows platform

Which of the following replication methods is best suited for de-normalizing tables?

A. Adaptive Apply

B. Summarization

C. Consolidation ?One-to-One

D. Consolidation ?One-to-Many

Assuming TABLE-A and TABLE-B are joined at source and replicated to TABLE-C at target, the replication type 'Consolidation `One-to-One' will replicate inserts and updates to TABLE-C only when ___________________.

A. TABLE-A is updated

B. TABLE-B is updated

C. both TABLE-A and TABLE-B are updated

D. All of the above.

Which of the following replication methods is best suited for re-assigning data values using lookup tables?

A. Adaptive Apply

B. Summarization

C. Consolidation ?One-to-One

D. Consolidation ?One-to-Many

Which of the following statements about CDC Metadata Schema is TRUE?

A. Each CDC instance must have its own unique CDC metadata schema.

B. Multiple CDC instances accessing the same data source can have a common CDC metadata schema.

C. Each CDC user should have their own unique CDC metadata schema.

D. Each database can contain one-and-only-one CDC metadata schema.

Which DataStage connectivity object is used to integrate CDC with DataStage?

A. MQ Stage

B. CDC Transaction Stage

C. DB2 Connect Stage

D. ODBC Stage

Which of the following objects is INVALID in the target table for LiveAudit replication?

A. after image columns of changed rows

B. before image columns of changed rows

C. primary key

D. derived columns