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: 21

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

  1. System Administrator, Administrator, Operator and Monitor

  2. System Administrator, Database Administrator, Operator and Monitor

  3. System Administrator, Administrator, Replication User and Monitor

  4. System Administrator, Database Administrator, Replication User and Monitor

Answer: A

Question No: 22

Which of the following will be a valid SOURCE for quot;InfoSphere Change Data Capture for Oracle Replicationquot;?

  1. Oracle database running on any supported platform

  2. Oracle database running on Windows platform only

  3. Any heterogeneous data source running on any supported hardware platform

  4. Any heterogeneous data source running on Windows platform

Answer: A

Question No: 23

A CDC administrator is being asked to replicate warehouse data to a reporting server in order to facilitate generating daily, weekly, and monthly performance reports for the management. Which of the following setups, in your opinion, is considered a #39;best practice#39;?

  1. Replicate all tables using quot;Refreshquot; mode but run them once a day, week, or month

  2. Replicate all tables using quot;Mirror Continuousquot; mode but run them once a day, week, or

    month

  3. Replicate all tables using quot;Mirror Continuousquot; method and run them continuously

  4. Replicate only quot;Summarizedquot; data using quot;Mirror Continuousquot; method and run them once a day, week, or month as necessary

Answer: C

Question No: 24

A given CDC instance can capture changes from .

  1. active and archive logs located local to the CDC instance belonging to a single database

  2. active and archive logs located local to the CDC instance belonging to multiple databases of the same type (such as DB2)

  3. active and archive logs located remote from the CDC instance belonging to multiple databases of the same type (such as DB2)

  4. active and archive logs located local to the CDC instance belonging to multiple databases of different types (such as DB2, Oracle, SQL Server etc)

Answer: A

Question No: 25

How is Zero Latency replication capability architected in CDC?

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

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

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

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

Answer: D

Question No: 26

Assuming TABLE-A and TABLE-B are joined at source and replicated to TABLE-C at target, the replication type #39;Consolidation ‘One-to-One#39; will replicate inserts and updates to TABLE-C only when .

  1. TABLE-A is updated

  2. TABLE-B is updated

  3. both TABLE-A and TABLE-B are updated

  4. All of the above.

Answer: D

Question No: 27

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

  1. The CDC instance cannot be connected

  2. The datastore cannot be created or connected

  3. The subscription that uses the source datastore cannot be created

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

Answer: D

Question No: 28

Which of the following products use InfoSphere DataStage as target database, and licensing based on the size of the DataStage server?

  1. InfoSphere Change Data Capture (CDC)

  2. InfoSphere Change Data Delivery (CDD)

  3. InfoSphere Replication Server

  4. InfoSphere Classic Replication Server

Answer: B

Question No: 29

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

  1. MQ Stage

  2. CDC Transaction Stage

  3. DB2 Connect Stage

  4. ODBC Stage

Answer: B

Question No: 30

Which of the following replication methods is best suited for re-assigning data values using lookup tables?

  1. Adaptive Apply

  2. Summarization

  3. Consolidation ?One-to-One

  4. Consolidation ?One-to-Many

Answer: D

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