Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

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

A customer needs a solution to replicate changes made to their inventory database that gets updated once a night in a batch processing environment. Can CDC perform this task?

Options:

A.

CDC is best suited for OLTP environments only.

B.

CDC is best suited for OLAP environments only.

C.

CDC is best suited for Batch Processing environments.

D.

CDC can be used in all environments as long as logging is NOT turned off.

Question 2

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 3

Which one of the following CDC capabilities is NOT promised to IBM customers?

Options:

A.

guaranteed data integrity

B.

zero latency

C.

dynamic change data integration

D.

near real-time data synchronization

Question 4

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 5

Which of the following statements about the Access Server is FALSE?

Options:

A.

Operating system users can connect to the Access Server.

B.

Access Server can be accessed by one or more remote Management Consoles.

C.

Multiple Access Server services are permitted in a given CDC environment.

D.

None of the above.

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 CDC Users is FALSE?

Options:

A.

Multiple CDC users can be assigned to a single datastore.

B.

A single CDC user can be assigned to multiple datastores.

C.

A CDC user must be an Operating System user or a Database user.

D.

A CDC user need not be an Operating System user or a Database user.

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