IBM IBM Certifications P2090-011 Questions & Answers

• Question 21:

  A subscription is 'Parked' if ________________.

  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

  Correct Answer: D

• Question 22:

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

  A. Consolidation ?One-to-One

  B. Adaptive Apply

  C. Standard

  D. Summarization

  Correct Answer: A

• Question 23:

  Assuming the "Auto Start" option is enabled, what happens when the CDC subscription feeding to DataStage is stopped by the CDC user?

  A. DataStage job waits until the CDC subscription is restarted

  B. DataStage job receiving updates from the CDC subscription ends automatically

  C. DataStage job receiving updates from the CDC subscription generates error message

  D. DataStage job crashes with core dump

  Correct Answer: B

• Question 24:

  Can the port number originally assigned to a CDC instance be changed to a new value?

  A. Yes, by editing the CDC instance properties.

  B. Yes, by editing the Management Console properties.

  C. No, it requires the CDC instance be re-created from scratch.

  D. No, a port number once assigned to an instance cannot be changed.

  Correct Answer: A

• Question 25:

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

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

  B. between different pairs of Source and Target Tables.

  C. using different types of table mappings.

  D. All of the above.

  Correct Answer: D

• Question 26:

  What is the correct order of steps to follow when creating a replication subscription using the Management Console?

  A. create instance, create project, create user, assign user to the project, and create subscription

  B. create instance, create database, create user, assign user to the database, and create subscription

  C. create instance, create user, assign user to instance, and create subscription

  D. create instance, create user, create datastore, assign user to the datastore, and create subscription

  Correct Answer: D

• Question 27:

  Which of the following products belongs in the IBM Data Replication products family?

  A. InfoSphere Replication Server

  B. InfoSphere Classic Replication Server

  C. InfoSphere Change Data Capture

  D. All of the above.

  Correct Answer: D

• Question 28:

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

  A. System Administrator, Administrator, Operator and Monitor

  B. System Administrator, Database Administrator, Operator and Monitor

  C. System Administrator, Administrator, Replication User and Monitor

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

  Correct Answer: A

• Question 29:

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

  A. InfoSphere Replication Server

  B. InfoSphere Classic Replication Server

  C. InfoSphere Change Data Capture (CDC)

  D. InfoSphere DB2 Connect

  Correct Answer: C

• Question 30:

  A given CDC instance can capture changes from _________.

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

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

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

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

  Correct Answer: A