Which of the following set of databases can be valid "replication sources" for CDC?
A. DB2, Oracle, Informix and SQL Server
B. DB2, Oracle, Teradata and SQL Server
C. DB2, DataStage, IMS and IDMS
D. DB2, DataStage, Informix and MySQL
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
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 replication methods may be used to maintain inventory levels up-to- date in real-time?
A. Adaptive Apply
B. Summarization
C. Consolidation ?One-to-One
D. Consolidation ?One-to-Many
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 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.
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
An InfoSphere Change Data Capture (CDC) instance will NOT launch if _______________.
A. the instance metadata schema is dropped
B. the instance port number is used by another active process
C. the database access password has changed
D. All of the above.
How are the CDC subscription and DataStage job started when the "Auto start" option is not enabled?
A. Start the DataStage Job first, then start the CDC subscription
B. Start the CDC subscription first, then start the DataStage job
C. Start only the CDC subscription, and the DataStage job will be started automatically
D. It is not possible to start DataStage job, if "Auto start" option is not enabled
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-011 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.