IBM P2090-011 dumps - 100% Pass Guarantee!

Which of the following statements about CDC instances is FALSE?

A. CDC instances are created using the CDC Configuration Tool.

B. CDC instances require unique TCPIP port numbers.

C. A single CDC instance can be set up to access multiple data sources.

D. Multiple CDC instances can be set up to access a single data source.

A given CDC instance can capture changes from _________.

A. active and archive logs located local to the CDC instance belonging to a single database

B. active and archive logs located local to the CDC instance belonging to multiple databases of the same type (such as DB2)

C. active and archive logs located remote from the CDC instance belonging to multiple databases of the same type (such as DB2)

D. active and archive logs located local to the CDC instance belonging to multiple databases of different types (such as DB2, Oracle, SQL Serveretc)

Can the port number originally assigned to a CDC instance be changed to a new value?

A. Yes, by editing the CDC instance properties.

B. Yes, by editing the Management Console properties.

C. No, it requires the CDC instance be re-created from scratch.

D. No, a port number once assigned to an instance cannot be changed.

How does CDC perform Data Translation while executing a replication subscription?

A. Using Data translation values supplied via external lookup tables

B. Using Data translation values supplied via user exits

C. Using Data translation values specified under the 'Translation' tab while customizing table mappings

D. Using Data translation values specified as run-time parameters

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