IBM 000-N45 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 000-N45
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: Jun 09, 2026

Question #19

With DataStage Designer you CANNOT __________.

A. Create and reuse Table Definitions

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

C. Configure the deployment model

D. Compile and execute the DataStage jobs

Discussion 0

Correct Answer: C Vote an answer

Question #20

Which of the following is NOT a function provided by the DB2 Connector Stage?

A. Performs a lookup directly on a DB2 table

B. Automatically updates table definitions when a SQL type mismatch is detected

C. Deletes rows from a DB2 table

D. Reads a DB2 table

Discussion 0

Correct Answer: B Vote an answer

Question #21

Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

A. 0 indicates the key value has not changed

B. Adds a column which holds a value of true/false

C. Adds a column which holds a value of 0 or 1

D. 1 indicates the key value has changed

Discussion 0

Correct Answer: B Vote an answer

Question #22

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

A. You can only use existing, predefined queries

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

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

D. Queries can be saved in XML format

Discussion 0

Correct Answer: B Vote an answer

Question #23

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 #24

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

Download Free IBM 000-N45 Demo

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