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.