IBM P2090-045 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-045
Exam Name/Title: IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1
Certification Provider: IBM
Corresponding Certification: IBM Mastery

Exam Questions: 55
Updated On: May 27, 2026

Question #13

What is a descriptor file of a Dataset created by the Dataset Stage?

A. Contains the length of the data files

B. Contains the actual data in text format

C. Contains metadata, data location, but not the data itself

D. Contains the actual data in binary format

Discussion 0

Correct Answer: C Vote an answer

Question #14

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

A. Create

B. Append

C. Delete

D. Overwrite

Discussion 0

Correct Answer: C Vote an answer

Question #15

Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?

A. All of the above

B. None of the above

C. The database holding the Information Server Metadata Repository

D. The ASB agent

E. WAS (WebSphere Application Server)

Discussion 0

Correct Answer: B Vote an answer

Question #16

Which statement about Metadata Workbench is incorrect?

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

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

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

D. It displays data lineage reports

Discussion 0

Correct Answer: B Vote an answer

Question #17

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

A. Create multiple Exception Handlers stages to handle different types of failures

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. Define specific user variables and make them available within a Job Sequence

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

Discussion 0

Correct Answer: A Vote an answer

Question #18

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

A. Parallel jobs

B. Mainframe Jobs

C. Server jobs

D. Sequence Jobs

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM P2090-045 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-045 exam.