Latesttests
2017 Nov IBM Official New Released P2090-011
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/P2090-011.html

IBM InfoSphere Change Data Capture Technical Mastery Test v2

Question No: 1

Which of the following sets of replication modes is supported in CDC?

  1. Refresh, Net Change, Periodic

  2. Refresh, Continuous, Real-Time

  3. Refresh, Net Change, Continuous

  4. Log Based, Event Based, Trigger Based

Answer: C

Question No: 2

A subscription is #39;Parked#39; if .

  1. the subscription has finished executing a cycle

  2. the subscription has finished the initial refresh and is waiting for new changes

  3. the subscription has been copied/promoted/imported or renamed

  4. the subscription has been deactivated

Answer: D

Question No: 3

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

.

  1. the instance metadata schema is dropped

  2. the instance port number is used by another active process

  3. the database access password has changed

  4. All of the above.

Answer: D

Question No: 4

Is CDC capable of replicating DDL changes?

  1. Yes, this capability is natively built in to all editions of CDC.

  2. Yes, this capability can be implemented using CDC user exits.

  3. Yes, but this capability is limited to certain data sources and platforms at this time.

  4. None of the above.

Answer: C

Question No: 5

CDC is software solution that captures transforms and flows changed data from in real time.

  1. Database tables

  2. Enterprise application

  3. Database logs

  4. All of the above

Answer: C

Question No: 6

Which of the following objects is INVALID in the target table for LiveAudit replication?

  1. after image columns of changed rows

  2. before image columns of changed rows

  3. primary key

  4. derived columns

Answer: C

Question No: 7

Which of the following statements about CDC subscription members is TRUE? Different subscription members can replicate data:

  1. between the same pair of Source and Target Datastores.

  2. between different pairs of Source and Target Tables.

  3. using different types of table mappings.

  4. All of the above.

Answer: D

Question No: 8

Which of the following products is capable of replicating data from supported data sources to DB2 on z/OS?

  1. InfoSphere Replication Server for Linux for z Series

  2. InfoSphere Classic Replication Server for z/OS

  3. InfoSphere Change Data Capture (CDC) for z/OS

  4. All of the above.

Answer: D

Question No: 9

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

  1. Flat File, Staging Tables, Direct Connect and Shared Memory

  2. Flat File, Staging Tables, Direct Connect and Messaging Queue

  3. Flat File, Staging Tables, Direct Connect and Named Pipes

  4. All of the above.

Answer: B

Question No: 10

Which of the following statements about CDC instances is FALSE?

  1. CDC instances are created using the CDC Configuration Tool.

  2. CDC instances require unique TCPIP port numbers.

  3. A single CDC instance can be set up to access multiple data sources.

  4. Multiple CDC instances can be set up to access a single data source.

Answer: C

100% Free Download!
Download Free Demo:P2090-011 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-011 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE