Summer Sale 60% Special Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best60

Examstrust Logo
examstrust mcafee
  1. Home
  2. IBM
  3. SWG Technical Mastery
  4. P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1

IBM P2090-045 IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam Practice Test

Page: 1 / 6
Total 55 questions
Get P2090-045 Full Access Download P2090-045 PDF

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

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$68  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$48  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$42  $104.99
Add to Cart
Question 1

What objects below will you NOT be able to view with the Repository window in DataStage Designer Client?

Options:

A.

Parallel Jobs

B.

Table Definitions

C.

Logs

D.

Sequence Jobs

Question 2

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

Options:

A.

TXT and XML

B.

DSX and CSV

C.

DSX and XML

D.

TXT and CSV

Question 3

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

Options:

A.

Append

B.

Replace

C.

Truncate

D.

All of the above

Question 4

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

Options:

A.

Information Server Web Console

B.

DataStage Administrator

C.

DataStage Director

D.

DataStage Designer

Question 5

Which of the following statements about partitioning algorithms is correct?

Options:

A.

MODULUS and HASH ensure balanced data volumes in all the partitions

B.

For the Lookup reference stage, DataStage always uses the MODULUS method

C.

SAME partitioning method is the fastest algorithm because it does not require additional processing

D.

The grouping methods available in the Aggregator stage are MODULUS and HASH

Question 6

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

Options:

A.

Append

B.

Overwrite

C.

Delete

D.

Create

Question 7

Which of the following statements about InfoSphere Data Architect is correct?

Options:

A.

You CANNOT create a logical model from a physical model

B.

InfoSphere Data Architect can deploy physical data models directly to the database management system

C.

Reverse engineering data models only works for DB2 databases

D.

InfoSphere Data Architect is installed using the Information Server installation wizard

Question 8

Under which scenario may a user benefit from using InfoSphere Discovery?

Options:

A.

Automate data relationship discovery

B.

Prototype a data model for the first time

C.

Automate transformation rule discovery

D.

Automate business object identification

E.

All of the above

Load More P2090-045 Questions
Page: 1 / 6
Total 55 questions
Get P2090-045 Full Access Download P2090-045 PDF