P2090-011 Online Practice Questions and Answers

Which one of the following CDC capabilities is NOT promised to IBM customers?

A. guaranteed data integrity

B. zero latency

C. dynamic change data integration

D. near real-time data synchronization

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.

Which of the following products belongs in the IBM Data Replication products family?

A. InfoSphere Replication Server

B. InfoSphere Classic Replication Server

C. InfoSphere Change Data Capture

D. All of the above.

Assuming the "Auto Start" option is enabled, what happens when the CDC subscription feeding to DataStage is stopped by the CDC user?

A. DataStage job waits until the CDC subscription is restarted

B. DataStage job receiving updates from the CDC subscription ends automatically

C. DataStage job receiving updates from the CDC subscription generates error message

D. DataStage job crashes with core dump

A subscription is 'Parked' if ________________.

A. the subscription has finished executing a cycle

B. the subscription has finished the initial refresh and is waiting for new changes

C. the subscription has been copied/promoted/imported or renamed

D. the subscription has been deactivated

Which of the following connection methods is used to integrate CDC with IBM Cognos?

A. Native IBM CognosNow! Web interface

B. Database Tables and Message Queues

C. Flat File, Direct Connect and Database Tables

D. Flat File, Direct Connect, Database Tables and Messaging Queues

Which of the following capabilities are available when integrating CDC with DataStage using Direct Connect method?

A. Auto-start/stop of DataStage Job

B. Two-way communication for status updates with CDC DataStage object

C. The ability to generate a default DataStage job using CDC that can be imported into and customized using DataStage

D. All of the above.

A customer needs a solution to replicate changes made to their inventory database that gets updated once a night in a batch processing environment. Can CDC perform this task?

A. CDC is best suited for OLTP environments only.

B. CDC is best suited for OLAP environments only.

C. CDC is best suited for Batch Processing environments.

D. CDC can be used in all environments as long as logging is NOT turned off.

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

CDC is software solution that captures transforms and flows changed data from______________________ in real time.

A. Database tables

B. Enterprise application

C. Database logs

D. All of the above