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
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
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 additional step may be needed to configure bi-directional replication?
A. specify 'Conflict Detection' rules
B. specify Primary Key
C. specify a Unique Index
D. restart the CDC source instance
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.
What happens when a new CDC subscription is created while database logging is turned off at the source?
A. The CDC instance cannot be connected
B. The datastore cannot be created or connected
C. The subscription that uses the source datastore cannot be created
D. When the subscription is started using the Management Console, the replication will not succeed.
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
What additional software is needed to develop and compile your own Java User Exits in CDC?
A. Microsoft Visual C++ compiler
B. JDK only
C. Both JRE and JDK
D. No additional software is required
CDC guarantees data integrity by using two-phase commit operation between ____________.
A. source tables and source metadata
B. target tables and target metadata
C. source tables and target Tables
D. source metadata and target metadata
The default port number 10101 assigned to Access Server is ________________.
A. a fixed value pre-assigned by the software that can never be changed
B. a fixed value assigned by users at the time of installing the software
C. automatically assigned based on the license key
D. updatable by editing the Management Console properties
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.