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? With DataStage Designer you CANNOT __________. What objects below will you NOT be able to view with the Repository window in DataStage Designer Client? Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)? Which of the following is NOT a function provided by the DB2 Connector Stage? What capability does Information Services Director provide? In a Job Sequence, what is the purpose for the use of Checkpoints? Which of the following statements about FastTrack is incorrect? Which of the following is a valid Write Mode action in the Connector Stages? Information Services Director provides multiple binding options. Which of the following statements about bindings is correct? What are the file format types when you use DataStage Designer to export objects? Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct? For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used? In Blueprint Director, how do you easily recognize that an element contains a subdiagram? Using a Job Sequence, which of the following tasks CANNOT be performed? Which of the following statements about InfoSphere Data Architect is correct? Which of the following stages is NOT a file data access 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 Where are Table Definitions stored? Which Stage requires identical metadata in order to combine data? In DataStage, Table Definitions can be imported through __________. Which of the following CANNOT be defined in the DataStage configuration file? Which of the following is NOT a valid File Update Mode property setting of a Sequential File Stage? Which of the following statements is not a supported matching option of the Lookup Stage? What is a supported function of the Dataset Management Utility? Which of the following is NOT possible with a Transformer Stage? The ODBC Connector Stage can be used to connect to __________. Under which scenario may a user benefit from using InfoSphere Discovery? How can FastTrack speed up the process of creating new source-to-target mapping specifications? Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage? DataStage Parallel Engine supports __________. Where can Job Parameters be used for DataStage parallel job development? Which statement about Metadata Workbench is incorrect? Which tool below can be used to assign permissions to users for each DataStage project? 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? A Job Sequence CANNOT contain __________. Which of the following statements about the Lookup Stage is correct? In DataStage, which client can be used to set environment variables at project level? 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 is an INVALID description of the Sort Stage Option Create Key Change Column? 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? Which of the following statements about Collecting methods is correct? In DataStage Sequential File Stage, how is a NULL value represented? What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option? Which of the following is a valid Write Table action in the Connector Stages? Which of the following is a standard practice when using partition parallelism? Which of the following components need to be up and running in order to use InfoSphere Discovery Studio? A Transformer Stage can have __________. What is a descriptor file of a Dataset created by the Dataset Stage? A DataStage job can be executed from_______________