Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

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

Demo: 8 questions
Total 55 questions

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

Question 1

Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?

Options:

A.

In a query, the criteria used for filtering the desired metadata can be based on different asset types

B.

Queries can be saved in XML format

C.

You can only use existing, predefined queries

D.

Queries can report on objects that are not stored in the Metadata Repository

Question 2

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

Options:

A.

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

B.

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

C.

Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them

D.

Create multiple Exception Handlers stages to handle different types of failures

Question 3

In Blueprint Director, how do you easily recognize that an element contains a subdiagram?

Options:

A.

There is a little ?icon associated with the elementThere is a little ??icon associated with the element

B.

There is a little green arrow associated to the element

C.

There is a little ??icon associated with the element

D.

Double clicking the element is the only way to find out

Question 4

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 5

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 6

Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?

Options:

A.

Server jobs

B.

Parallel jobs

C.

Sequence Jobs

D.

Mainframe Jobs

Question 7

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 8

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

Options:

A.

DataStage Designer

B.

DataStage Administrator

C.

DataStage Director

D.

Information Server Web Console

Demo: 8 questions
Total 55 questions