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 of the following statements about 'Create CDC instance' is TRUE?

A. CDC instance creation will fail if logging is turned off at the source.

B. CDC instance creation will fail if logging is turned off at the target.

C. CDC instance creation will succeed with a warning message, if logging is turned off.

D. CDC instance creation will fail if logging is turned off both at the source and the target.

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

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

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 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.

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