Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

Note! Following P2090-011 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Questions 4

Which DataStage connectivity object is used to integrate CDC with DataStage?

Options:

A.

MQ Stage

B.

CDC Transaction Stage

C.

DB2 Connect Stage

D.

ODBC Stage

Buy Now
Questions 5

What happens when a new CDC subscription is created while database logging is turned off at the source?

Options:

A.

The CDC instance cannot be connected

B.

The datastore cannot be created or connected

C.

The subscription that uses the source datastore cannot be created

D.

When the subscription is started using the Management Console, the replication will not succeed.

Buy Now
Questions 6

An InfoSphere Change Data Capture (CDC) instance will NOT launch if _______________.

Options:

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.

Buy Now
Questions 7

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 ___________________.

Options:

A.

TABLE-A is updated

B.

TABLE-B is updated

C.

both TABLE-A and TABLE-B are updated

D.

All of the above.

Buy Now
Exam Code: P2090-011
Exam Name: IBM InfoSphere Change Data Capture Technical Mastery Test v2
Last Update: Apr 14, 2023
Questions: 51