New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium IBM P2090-011 Dumps Questions Answers

Page: 1 / 2
Total 51 questions

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

Question 1

Which of the following capabilities are available when integrating CDC with DataStage using Direct Connect method?

Options:

A.

Auto-start/stop of DataStage Job

B.

Two-way communication for status updates with CDC DataStage object

C.

The ability to generate a default DataStage job using CDC that can be imported into and customized using DataStage

D.

All of the above.

Buy Now
Question 2

Which of the following sets of user roles is supported in CDC?

Options:

A.

System Administrator, Administrator, Operator and Monitor

B.

System Administrator, Database Administrator, Operator and Monitor

C.

System Administrator, Administrator, Replication User and Monitor

D.

System Administrator, Database Administrator, Replication User and Monitor

Question 3

How is Zero Latency replication capability architected in CDC?

Options:

A.

Zero Latency replication capability is natively built in to all IBM replication products.

B.

Zero Latency replication capability is possible, if plenty of system resources (CPU, memory, bandwidth etc) are allocated to CDC.

C.

Zero Latency replication capability is built into the Advanced and Ultimate editions of CDC that can be purchased for an additional licensingfee.

D.

Zero Latency replication is possible only when every component participating in the overall replication solution is tuned for best performance.Therefore IBM will not provide explicit guarantees for Zero Latency while selling CDC to its customers.

Question 4

Which of the following statements about CDC Metadata Schema is TRUE?

Options:

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.

Question 5

How are the CDC subscription and DataStage job started when the "Auto start" option is not enabled?

Options:

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

Question 6

The default port number 10101 assigned to Access Server is ________________.

Options:

A.

a fixed value pre-assigned by the software that can never be changed

B.

a fixed value assigned by users at the time of installing the software

C.

automatically assigned based on the license key

D.

updatable by editing the Management Console properties

Question 7

What is the correct table mapping type to choose for a member of the subscription that will be used for de-normalizing tables?

Options:

A.

Consolidation ?One-to-One

B.

Adaptive Apply

C.

Standard

D.

Summarization

Exam Detail
Vendor: IBM
Exam Code: P2090-011
Last Update: Dec 22, 2024
P2090-011 Question Answers
Page: 1 / 2
Total 51 questions