IBM P2090-011 - IBM InfoSphere Change Data Capture Technical Mastery Test v2 Exam
Page: 3 / 11
Total 51 questions
Question #11 (Topic: )
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.
Answer: A
Question #12 (Topic: )
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
Answer: C
Question #13 (Topic: )
What additional software is needed to develop and compile your own Java User Exits in
CDC?
CDC?
A. Microsoft Visual C++ compiler
B. JDK only
C. Both JRE and JDK
D. No additional software is required
Answer: B
Question #14 (Topic: )
How are the CDC subscription and DataStage job started when the "Auto start" option is
not enabled?
not enabled?
A. Start the DataStage Job first, then start the CDC subscription
B. Start the CDC subscription first, then start the DataStage job
C. Start only the CDC subscription, and the DataStage job will be started automatically
D. It is not possible to start DataStage job, if "Auto start" option is not enabled
Answer: B
Question #15 (Topic: )
Which of the following database objects can be replicated while integrating heterogeneous
data sources?
data sources?
A. Tables and Stored Procedures
B. Tables and Tablespaces
C. Tables and Views
D. Table objects only
Answer: D
