[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-046 Dumps with VCE and PDF 1-10

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

IBM InfoSphere Business Information Exchange Technical Mastery Test v1

Question No: 1

For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used?

  1. Microsoft SQL Server

  2. Informix

  3. DB2 UDB

  4. Oracle

Answer: B

Question No: 2

Where are Table Definitions stored?

  1. Information Server metadata repository

  2. In the file system as a binary file

  3. In the file system as a csv file

  4. None of the above

Answer: A

Question No: 3

Which of the following is a valid Write Table action in the Connector Stages?

  1. Append

  2. Replace

  3. Truncate

  4. All of the above

Answer: D

Question No: 4

Which type of Join would you select for the Join Stage to output unmatched records from both input data sources?

  1. Inner join

  2. Left outer join

  3. Right outer join

  4. Full outer join

Answer: D

Question No: 5

In a Job Sequence, what is the purpose for the use of Checkpoints?

  1. Monitor performance and failure for each stage

  2. Automatically restart a job

  3. Record the log information for each trigger

  4. Restart a job from the latest Checkpoint in case of job failures

Answer: D

Question No: 6

Using a Job Sequence, which of the following tasks CANNOT be performed?

  1. Define specific user variables and make them available within a Job Sequence

  2. Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory

  3. Run two different parallel jobs in sequence and use job parameters to pass different

    $APT_CONFIG _FILE values for each of them

  4. Create multiple Exception Handlers stages to handle different types of failures

Answer: D

Question No: 7

Which statement about Metadata Workbench is incorrect?

  1. It can extend data lineage to display data integration flows that are outside of Information Server

  2. It relies on the repository functions in DataStage Designer for impact analysis

  3. It displays data lineage reports

  4. It allows Metadata Workbench administrators to associate data stewards with data objects

Answer: B

Question No: 8

A Job Sequence CANNOT contain .

  1. Transformer Stages

  2. Sequencer Stages

  3. Triggers

  4. Job Activity Stages

Answer: A

Question No: 9

In DataStage, which client can be used to set environment variables at project level?

  1. DataStage Designer

  2. DataStage Administrator

  3. DataStage Director

  4. Information Server Web Console

Answer: B

Question No: 10

What action will a Lookup Stage take when quot;Dropquot; is selected as the Lookup Failure Option?

  1. Stage reports an error

  2. Stage skips the input record

  3. Stage rejects the Input record

  4. Job gets aborted

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-046 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-046 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.