IBM P2090-011 - IBM InfoSphere Change Data Capture Technical Mastery Test v2 Exam
Page: 1 / 11
Total 51 questions
Question #1 (Topic: )
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
Question #2 (Topic: )
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
Question #3 (Topic: )
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
Question #4 (Topic: )
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
Question #5 (Topic: )
CDC is software solution that captures transforms and flows changed data
from______________________ in real time.
from______________________ in real time.
A. Database tables
B. Enterprise application
C. Database logs
D. All of the above
Answer: C
