P2090-045 - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam
Go back to
IBM
Example Questions
Which description below about the Sort Stage is invalid?
All the incoming records must have different values for sorting key
With DataStage Designer you CANNOT __________.
Configure the deployment model
What objects below will you NOT be able to view with the Repository window in DataStage Designer Client?
Logs
Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?
Parallel jobs
Which of the following is NOT a function provided by the DB2 Connector Stage?
Automatically updates table definitions when a SQL type mismatch is detected
What capability does Information Services Director provide?
Information Services Director is the tool used within Information Server to create and to deploy an application containing one or more services
In a Job Sequence, what is the purpose for the use of Checkpoints?
Restart a job from the latest Checkpoint in case of job failures
Which of the following statements about FastTrack is incorrect?
The only way to combine data in a FastTrack mapping specification is to create a lookup definition
Which of the following is a valid Write Mode action in the Connector Stages?
All of the above
Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?
Multiple bindings can be associated to the same service
What are the file format types when you use DataStage Designer to export objects?
DSX and XML
Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?
In a query, the criteria used for filtering the desired metadata can be based on different asset types
For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used?
Informix
In Blueprint Director, how do you easily recognize that an element contains a subdiagram?
There is a little ??icon associated with the element
Using a Job Sequence, which of the following tasks CANNOT be performed?
Create multiple Exception Handlers stages to handle different types of failures
Which of the following statements about InfoSphere Data Architect is correct?
InfoSphere Data Architect can deploy physical data models directly to the database management system
Which of the following stages is NOT a file data access stage?
Transformer Stage
Which functionalities are supported by InfoSphere Discovery? I.Discover primary / foreign key relationships between tables II.Discover statistics about usage of data by users III.Discover matching source and target columns IV.Discover suggested transformations that, when applied, will transform the data from the source columns to match the data in the target columns
I, III, IV
Where are Table Definitions stored?
Information Server metadata repository
Which Stage requires identical metadata in order to combine data?
Funnel Stage
In DataStage, Table Definitions can be imported through __________.
DataStage Designer
Which of the following CANNOT be defined in the DataStage configuration file?
Compilation options for DataStage jobs
Which of the following is NOT a valid File Update Mode property setting of a Sequential File Stage?
Delete
Which of the following statements is not a supported matching option of the Lookup Stage?
Range on the Target Link
What is a supported function of the Dataset Management Utility?
Copies, views and deletes the dataset
Which of the following is NOT possible with a Transformer Stage?
Create and compile a custom function to be used in output link derivations
The ODBC Connector Stage can be used to connect to __________.
All of the above
Under which scenario may a user benefit from using InfoSphere Discovery?
All of the above
How can FastTrack speed up the process of creating new source-to-target mapping specifications?
I, II, IV
Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?
Reject
DataStage Parallel Engine supports __________.
Pipeline and Partition Parallelism
Where can Job Parameters be used for DataStage parallel job development?
All of the above
Which statement about Metadata Workbench is incorrect?
It relies on the repository functions in DataStage Designer for impact analysis
Which tool below can be used to assign permissions to users for each DataStage project?
DataStage Administrator
A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?
Sort
A Job Sequence CANNOT contain __________.
Transformer Stages
Which of the following statements about the Lookup Stage is correct?
It combines data horizontally
In DataStage, which client can be used to set environment variables at project level?
DataStage Administrator
In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?
To bring Cognos BI reports and queries into the Metadata Repository
Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?
Adds a column which holds a value of true/false
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?
If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together
Which of the following statements about Collecting methods is correct?
SORT MERGE never performs data sorting
In DataStage Sequential File Stage, how is a NULL value represented?
As defined by the Developer in the extended properties of the field
What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?
Stage skips the input record
Which of the following is a valid Write Table action in the Connector Stages?
All of the above
Which of the following is a standard practice when using partition parallelism?
Avoid repartitioning if possible
Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?
None of the above
A Transformer Stage can have __________.
One input link, one reject link, one otherwise link, one or more output links
What is a descriptor file of a Dataset created by the Dataset Stage?
Contains metadata, data location, but not the data itself
A DataStage job can be executed from_______________
DataStage Designer or Director client.