Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Certensure Logo
  1. Home
  2. IBM
  3. SWG Technical Mastery
  4. P2090-011 - IBM InfoSphere Change Data Capture Technical Mastery Test v2

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

Demo: 7 questions
Total 51 questions
Get P2090-011 Full Access Download P2090-011 PDF

IBM InfoSphere Change Data Capture Technical Mastery Test v2 Questions and Answers

Question 1

Which additional step may be needed to configure bi-directional replication?

Options:

A.

specify 'Conflict Detection' rules

B.

specify Primary Key

C.

specify a Unique Index

D.

restart the CDC source instance

Question 2

Which of the following connection methods is used to integrate CDC with InfoSphere DataStage?

Options:

A.

Flat File, Staging Tables, Direct Connect and Shared Memory

B.

Flat File, Staging Tables, Direct Connect and Messaging Queue

C.

Flat File, Staging Tables, Direct Connect and Named Pipes

D.

All of the above.

Question 3

Which of the following will be a valid SOURCE for "InfoSphere Change Data Capture (CDC) for Oracle Triggers"?

Options:

A.

Local Oracle databases running on any supported platform

B.

Remote Oracle databases running on any supported platform

C.

Both local and remote Oracle databases running on any supported platform

D.

Heterogeneous databases running on any supported platform

Question 4

Which of the following set of databases can be valid "replication sources" for CDC?

Options:

A.

DB2, Oracle, Informix and SQL Server

B.

DB2, Oracle, Teradata and SQL Server

C.

DB2, DataStage, IMS and IDMS

D.

DB2, DataStage, Informix and MySQL

Question 5

Can the port number originally assigned to a CDC instance be changed to a new value?

Options:

A.

Yes, by editing the CDC instance properties.

B.

Yes, by editing the Management Console properties.

C.

No, it requires the CDC instance be re-created from scratch.

D.

No, a port number once assigned to an instance cannot be changed.

Question 6

Which of the following replication methods is best suited for de-normalizing tables?

Options:

A.

Adaptive Apply

B.

Summarization

C.

Consolidation ?One-to-One

D.

Consolidation ?One-to-Many

Question 7

Which of the following statements about 'Create CDC instance' is TRUE?

Options:

A.

CDC instance creation will fail if logging is turned off at the source.

B.

CDC instance creation will fail if logging is turned off at the target.

C.

CDC instance creation will succeed with a warning message, if logging is turned off.

D.

CDC instance creation will fail if logging is turned off both at the source and the target.

Load More P2090-011 Questions
Demo: 7 questions
Total 51 questions
Get P2090-011 Full Access Download P2090-011 PDF