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

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

Which of the following statements about CDC Metadata Schema is TRUE?

  1. Each CDC instance must have its own unique CDC metadata schema.

  2. Multiple CDC instances accessing the same data source can have a common CDC metadata schema.

  3. Each CDC user should have their own unique CDC metadata schema.

  4. Each database can contain one-and-only-one CDC metadata schema.

Answer: A

Question No: 12

Which of the following replication methods is best suited for de-normalizing tables?

  1. Adaptive Apply

  2. Summarization

  3. Consolidation ?One-to-One

  4. Consolidation ?One-to-Many

Answer: C

Question No: 13

What additional software is needed to develop and compile your own Java User Exits in CDC?

  1. Microsoft Visual C compiler

  2. JDK only

  3. Both JRE and JDK

  4. No additional software is required

Answer: B

Question No: 14

How are the CDC subscription and DataStage job started when the quot;Auto startquot; option is not enabled?

  1. Start the DataStage Job first, then start the CDC subscription

  2. Start the CDC subscription first, then start the DataStage job

  3. Start only the CDC subscription, and the DataStage job will be started automatically

  4. It is not possible to start DataStage job, if quot;Auto startquot; option is not enabled

Answer: B

Question No: 15

Which of the following database objects can be replicated while integrating heterogeneous data sources?

  1. Tables and Stored Procedures

  2. Tables and Tablespaces

  3. Tables and Views

  4. Table objects only

Answer: D

Question No: 16

Which of the following statements about the Access Server is FALSE?

  1. Operating system users can connect to the Access Server.

  2. Access Server can be accessed by one or more remote Management Consoles.

  3. Multiple Access Server services are permitted in a given CDC environment.

  4. None of the above.

Answer: A

Question No: 17

Which of the following statements about CDC Datastores is FALSE?

  1. You need to assign a user to the datastore before it can be used.

  2. Multiple datastores can access a single CDC instance.

  3. A single datastore can access multiple CDC instances.

  4. Multiple CDC users can access a single datastore.

Answer: C

Question No: 18

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

  1. InfoSphere Replication Server

  2. InfoSphere Classic Replication Server

  3. InfoSphere Change Data Capture

  4. All of the above.

Answer: D

Question No: 19

Which of the following set of databases can be valid quot;replication sourcesquot; for CDC?

  1. DB2, Oracle, Informix and SQL Server

  2. DB2, Oracle, Teradata and SQL Server

  3. DB2, DataStage, IMS and IDMS

  4. DB2, DataStage, Informix and MySQL

Answer: A

Question No: 20

Which one of the following CDC capabilities is NOT promised to IBM customers?

  1. guaranteed data integrity

  2. zero latency

  3. dynamic change data integration

  4. near real-time data synchronization

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

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.