[Free] 2018(Jan) Dumps4cert Passguide IBM M2090-744 Dumps with VCE and PDF 1-10

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released M2090-744
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/M2090-744.html

IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1

Question No: 1

Which of the following is NOT a valid File Update Mode property setting of a Sequential File Stage?

  1. Append

  2. Overwrite

  3. Delete

  4. Create

Answer: C

Question No: 2

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

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

Which of the following statements about the Lookup Stage is correct?

  1. It is a Real-Time Stage

  2. It combines data horizontally

  3. It can have only one input link defined

  4. The default partition method for Lookup is Hash

Answer: B

Question No: 5

In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?

  1. To bring runtime information about DataStage jobs into the Metadata Repository

  2. To bring FastTrack mapping specifications into the Metadata Repository

  3. To bring Cognos BI reports and queries into the Metadata Repository

  4. To bring a blueprint from Blueprint Director into the Metadata Repository

Answer: C

Question No: 6

Which of the following stages is NOT a file data access stage?

  1. Sequential File Stage

  2. Transformer Stage

  3. Dataset Stage

  4. FileSet Stage

Answer: B

Question No: 7

A Transformer Stage can have .

  1. One input link, one or more reject links, one otherwise link, one or more output links

  2. One or more input links, one or more reject links, one otherwise link, one or more output links

  3. One input link, one reject link, one otherwise link, one or more output links

  4. One or more input links, one reject link, one otherwise link, one or more output links

Answer: C

Question No: 8

Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

  1. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

  2. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

  3. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results

  4. ROUND ROBIN ensures correct results

Answer: A

Question No: 9

A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?

  1. Hash

  2. Sort

  3. Random

  4. Round Robin

Answer: B

Question No: 10

Which of the following statements about FastTrack is incorrect?

  1. The only way to combine data in a FastTrack mapping specification is to create a lookup definition

  2. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems

  3. When generating a job from a FastTrack specification, you can specify the desired stage

    type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)

  4. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:M2090-744 Demo PDF
100% Dumps4cert Free Guaranteed!
M2090-744 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE 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.