IBM P2090-011 - IBM InfoSphere Change Data Capture Technical Mastery Test v2 Exam

Page:    1 / 11   
Total 51 questions

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


Answer : C

A subscription is 'Parked' if ________________.

  • A. the subscription has finished executing a cycle
  • B. the subscription has finished the initial refresh and is waiting for new changes
  • C. the subscription has been copied/promoted/imported or renamed
  • D. the subscription has been deactivated


Answer : D

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.


Answer : D

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.


Answer : C

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


Answer : C

Page:    1 / 11   
Total 51 questions