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

Certensure Logo
  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

Demo: 8 questions
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

Question 1

Which of the following statements is not a supported matching option of the Lookup Stage?

Options:

A.

Equality match

B.

Caseless match

C.

Range on the Target Link

D.

Range on the Reference Link

Question 2

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

Options:

A.

Sequential File Stage

B.

Transformer Stage

C.

Dataset Stage

D.

FileSet Stage

Question 3

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

Options:

A.

Inner join

B.

Left outer join

C.

Right outer join

D.

Full outer join

Question 4

Which of the following statements about Blueprint Director is incorrect?

Options:

A.

Blueprint Director will display the time needed to perform individual tasks

B.

You can browse and search Information Server metadata assets

C.

You can create new blueprints from standard reference architecture templates

D.

Reference architectures contain detailed method guidance for required activities

Question 5

Which statement about Metadata Workbench is incorrect?

Options:

A.

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

B.

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

C.

It displays data lineage reports

D.

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

Question 6

In DataStage, Table Definitions can be imported through __________.

Options:

A.

DataStage Administrator

B.

Information Server Web Console

C.

DataStage Designer

D.

DataStage Director

Question 7

With DataStage Designer you CANNOT __________.

Options:

A.

Design jobs that extract, integrate, and transform the data for data warehouse

B.

Create and reuse Table Definitions

C.

Compile and execute the DataStage jobs

D.

Configure the deployment model

Question 8

Where can Job Parameters be used for DataStage parallel job development?

Options:

A.

In directory and file names

B.

In constraints and file names

C.

In constraints and derivations

D.

All of the above

Load More P2090-045 Questions
Demo: 8 questions
Total 55 questions
Get P2090-045 Full Access Download P2090-045 PDF