[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-011 Dumps with VCE and PDF 1-10

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-011
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.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% Ensurepass Free Download!
Download Free Demo:P2090-011 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-011 Dumps

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.