[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-011 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-011
100% Free Download! 100% Pass Guaranteed!

IBM InfoSphere Change Data Capture Technical Mastery Test v2

Question No: 31

The Monitoring tab in Management Console allows users to .

  1. view Subscription Status, Replication Statistics, and Event Logs

  2. display Latency amp; Replication Diagrams

  3. setup Alerts amp; Notifications

  4. All of the above.

Answer: D

Question No: 32

The default port number 10101 assigned to Access Server is .

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

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

  3. automatically assigned based on the license key

  4. updatable by editing the Management Console properties

Answer: D

Question No: 33

CDC guarantees data integrity by using two-phase commit operation between


  1. source tables and source metadata

  2. target tables and target metadata

  3. source tables and target Tables

  4. source metadata and target metadata

Answer: B

Question No: 34

Which of the following products is best suited for heterogeneous data replication between DB2 and SQL Server?

  1. InfoSphere Replication Server

  2. InfoSphere Classic Replication Server

  3. InfoSphere Change Data Capture (CDC)

  4. InfoSphere DB2 Connect

Answer: C

Question No: 35

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?

  1. CDC is best suited for OLTP environments only.

  2. CDC is best suited for OLAP environments only.

  3. CDC is best suited for Batch Processing environments.

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

Answer: D

Question No: 36

Which of the following connection methods is used to integrate CDC with IBM Cognos?

  1. Native IBM CognosNow! Web interface

  2. Database Tables and Message Queues

  3. Flat File, Direct Connect and Database Tables

  4. Flat File, Direct Connect, Database Tables and Messaging Queues

Answer: B

Question No: 37

How does CDC perform Data Translation while executing a replication subscription?

  1. Using Data translation values supplied via external lookup tables

  2. Using Data translation values supplied via user exits

  3. Using Data translation values specified under the #39;Translation#39; tab while customizing table mappings

  4. Using Data translation values specified as run-time parameters

Answer: C

Question No: 38

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

  1. Consolidation ?One-to-One

  2. Adaptive Apply

  3. Standard

  4. Summarization

Answer: A

Question No: 39

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

  1. Auto-start/stop of DataStage Job

  2. Two-way communication for status updates with CDC DataStage object

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

  4. All of the above.

Answer: D

Question No: 40

Which of the following replication methods may be used to maintain inventory levels up-to- date in real-time?

  1. Adaptive Apply

  2. Summarization

  3. Consolidation ?One-to-One

  4. Consolidation ?One-to-Many

Answer: B

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
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

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