P2090-045 Exam Questions

Which tool below can be used to assign permissions to users for each DataStage project?

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

DataStage Parallel Engine supports __________.

Where are Table Definitions stored?

Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?

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?

Which of the following statements about FastTrack is incorrect?

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

With DataStage Designer you CANNOT __________.

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?

Which of the following statements about the Lookup Stage is correct?

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

A DataStage job can be executed from_______________

Which of the following is NOT possible with a Transformer Stage?

Under which scenario may a user benefit from using InfoSphere Discovery?

Which of the following statements about Blueprint Director is incorrect?

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

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

What are the file format types when you use DataStage Designer to export objects?

Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?

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

Which description below about the Sort Stage is invalid?

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

The ODBC Connector Stage can be used to connect to __________.

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

What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?

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

A Transformer Stage can have __________.

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

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

A customer has set up a survey using layout templates but, after activating the survey, notices that graphics and templates are not appearing. What component of Data Collection Web...

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

Which of the following is a valid Write Table action in the Connector Stages?

Which of the following CANNOT be defined in the DataStage configuration file?

How can FastTrack speed up the process of creating new source-to-target mapping specifications? I.Reverse engineer existing DataStage jobs II.Automatically discover column mappings...

What is a supported function of the Dataset Management Utility?

What objects below will you NOT be able to view with the Repository window in DataStage Designer Client?

Which of the following statements about InfoSphere Data Architect is correct?

With Information Services Director, you can deploy services that package the following information provider types: I.DataStage and QualityStage jobs II.SOAP over HTTP III.DB2 and O...

Which of the following statements about Collecting methods is correct?

A Job Sequence CANNOT contain __________.

In DataStage, Table Definitions can be imported through __________.

In DataStage Sequential File Stage, how is a NULL value represented?

Which Stage requires identical metadata in order to combine data?

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.D...

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

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 partit...

Which of the following statements about partitioning algorithms is correct?

Which of the following is a valid Write Mode action in the Connector Stages?

Which statement about Metadata Workbench is incorrect?