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
Which of the following statements about CDC Datastores is FALSE?
A. You need to assign a user to the datastore before it can be used.
B. Multiple datastores can access a single CDC instance.
C. A single datastore can access multiple CDC instances.
D. Multiple CDC users can access a single datastore.
Which of the following objects is INVALID in the target table for LiveAudit replication?
A. after image columns of changed rows
B. before image columns of changed rows
C. primary key
D. derived columns
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
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.
Which DataStage connectivity object is used to integrate CDC with DataStage?
A. MQ Stage
B. CDC Transaction Stage
C. DB2 Connect Stage
D. ODBC Stage
Which of the following statements about the Access Server is FALSE?
A. Access Server needs to run all of the time while replication is running.
B. Configuring Replication using Management Console is not possible without Access Server.
C. Monitoring using Management Console is not possible without Access Server.
D. None of the above.
Which of the following products is capable of replicating data from supported data sources to DB2 on z/OS?
A. InfoSphere Replication Server for Linux for z Series
B. InfoSphere Classic Replication Server for z/OS
C. InfoSphere Change Data Capture (CDC) for z/OS
D. All of the above.
Which of the following replication methods is best suited for re-assigning data values using lookup tables?
A. Adaptive Apply
B. Summarization
C. Consolidation ?One-to-One
D. Consolidation ?One-to-Many
Which of the following statements about the Access Server is FALSE?
A. Operating system users can connect to the Access Server.
B. Access Server can be accessed by one or more remote Management Consoles.
C. Multiple Access Server services are permitted in a given CDC environment.
D. None of the above.
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.