P2090-011 Online Practice Questions and Answers

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.

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

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

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.

What is the correct order of steps to follow when creating a replication subscription using the Management Console?

A. create instance, create project, create user, assign user to the project, and create subscription

B. create instance, create database, create user, assign user to the database, and create subscription

C. create instance, create user, assign user to instance, and create subscription

D. create instance, create user, create datastore, assign user to the datastore, and create subscription

Is CDC capable of replicating DDL changes?

A. Yes, this capability is natively built in to all editions of CDC.

B. Yes, this capability can be implemented using CDC user exits.

C. Yes, but this capability is limited to certain data sources and platforms at this time.

D. None of the above.

Which of the following products use InfoSphere DataStage as target database, and licensing based on the size of the DataStage server?

A. InfoSphere Change Data Capture (CDC)

B. InfoSphere Change Data Delivery (CDD)

C. InfoSphere Replication Server

D. InfoSphere Classic Replication Server

Which of the following statements about CDC Users is FALSE?

A. Multiple CDC users can be assigned to a single datastore.

B. A single CDC user can be assigned to multiple datastores.

C. A CDC user must be an Operating System user or a Database user.

D. A CDC user need not be an Operating System user or a Database user.

A CDC administrator is being asked to replicate warehouse data to a reporting server in order to facilitate generating daily, weekly, and monthly performance reports for the management. Which of the following setups, in your opinion, is considered a 'best practice'?

A. Replicate all tables using "Refresh" mode but run them once a day, week, or month

B. Replicate all tables using "Mirror Continuous" mode but run them once a day, week, or month

C. Replicate all tables using "Mirror Continuous" method and run them continuously

D. Replicate only "Summarized" data using "Mirror Continuous" method and run them once a day, week, or month as necessary

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