Which of the following statements about CDC Metadata Schema is TRUE?
A. Each CDC instance must have its own unique CDC metadata schema.
B. Multiple CDC instances accessing the same data source can have a common CDC metadata schema.
C. Each CDC user should have their own unique CDC metadata schema.
D. Each database can contain one-and-only-one CDC metadata schema.
How is Zero Latency replication capability architected in CDC?
A. Zero Latency replication capability is natively built in to all IBM replication products.
B. Zero Latency replication capability is possible, if plenty of system resources (CPU, memory, bandwidth etc) are allocated to CDC.
C. Zero Latency replication capability is built into the Advanced and Ultimate editions of CDC that can be purchased for an additional licensingfee.
D. Zero Latency replication is possible only when every component participating in the overall replication solution is tuned for best performance.Therefore IBM will not provide explicit guarantees for Zero Latency while selling CDC to its customers.
A customer needs a solution to replicate changes made to their inventory database that gets updated once a night in a batch processing environment. Can CDC perform this task?
A. CDC is best suited for OLTP environments only.
B. CDC is best suited for OLAP environments only.
C. CDC is best suited for Batch Processing environments.
D. CDC can be used in all environments as long as logging is NOT turned off.
Assuming TABLE-A and TABLE-B are joined at source and replicated to TABLE-C at target, the replication type 'Consolidation `One-to-One' will replicate inserts and updates to TABLE-C only when ___________________.
A. TABLE-A is updated
B. TABLE-B is updated
C. both TABLE-A and TABLE-B are updated
D. All 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 capabilities are available when integrating CDC with DataStage using Direct Connect method?
A. Auto-start/stop of DataStage Job
B. Two-way communication for status updates with CDC DataStage object
C. The ability to generate a default DataStage job using CDC that can be imported into and customized using DataStage
D. All of the above.
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 connection methods is used to integrate CDC with IBM Cognos?
A. Native IBM CognosNow! Web interface
B. Database Tables and Message Queues
C. Flat File, Direct Connect and Database Tables
D. Flat File, Direct Connect, Database Tables and Messaging Queues
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
Which of the following replication methods is best suited for de-normalizing tables?
A. Adaptive Apply
B. Summarization
C. Consolidation ?One-to-One
D. Consolidation ?One-to-Many
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.