Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Examstrust Logo
examstrust mcafee
  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

Page: 1 / 5
Total 51 questions
Get P2090-011 Full Access Download P2090-011 PDF

IBM InfoSphere Change Data Capture Technical Mastery Test v2 Questions and Answers

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Add to Cart
Question 1

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 'best practice'?

Options:

A.

Replicate all tables using "Refresh" mode but run them once a day, week, or month

B.

Replicate all tables using "Mirror Continuous" mode but run them once a day, week, or month

C.

Replicate all tables using "Mirror Continuous" method and run them continuously

D.

Replicate only "Summarized" data using "Mirror Continuous" method and run them once a day, week, or month as necessary

Question 2

Which of the following set of databases can be valid "replication sources" for CDC?

Options:

A.

DB2, Oracle, Informix and SQL Server

B.

DB2, Oracle, Teradata and SQL Server

C.

DB2, DataStage, IMS and IDMS

D.

DB2, DataStage, Informix and MySQL

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

A subscription is 'Parked' if ________________.

Options:

A.

the subscription has finished executing a cycle

B.

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

C.

the subscription has been copied/promoted/imported or renamed

D.

the subscription has been deactivated

Question 5

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

Options:

A.

Auto-start/stop of DataStage Job

B.

Two-way communication for status updates with CDC DataStage object

C.

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

D.

All of the above.

Question 6

Which of the following statements about CDC instances is FALSE?

Options:

A.

CDC instances are created using the CDC Configuration Tool.

B.

CDC instances require unique TCPIP port numbers.

C.

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

D.

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

Question 7

Which of the following will be a valid SOURCE for "InfoSphere Change Data Capture for Oracle Replication"?

Options:

A.

Oracle database running on any supported platform

B.

Oracle database running on Windows platform only

C.

Any heterogeneous data source running on any supported hardware platform

D.

Any heterogeneous data source running on Windows platform

Load More P2090-011 Questions
Page: 1 / 5
Total 51 questions
Get P2090-011 Full Access Download P2090-011 PDF