PDF P2090-045 Study Guide

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

Question 5

Which tool below can be used to assign permissions to users for each DataStage project?

Options:

Information Server Web Console

DataStage Administrator

DataStage Director

DataStage Designer

Question 6

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?

Options:

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

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

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

ROUND ROBIN ensures correct results

Question 7

Where are Table Definitions stored?

Options:

Information Server metadata repository

In the file system as a binary file

In the file system as a csv file

None of the above

Question 8

What are the file format types when you use DataStage Designer to export objects?

Options:

TXT and XML

DSX and CSV

DSX and XML

TXT and CSV

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

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

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce