IBM IBM Certifications P2090-045 Questions & Answers

• Question 11:

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

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

  B. Queries can be saved in XML format

  C. You can only use existing, predefined queries

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

  Correct Answer: A

• Question 12:

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

  A. Append

  B. Overwrite

  C. Delete

  D. Create

  Correct Answer: C

• Question 13:

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

  A. TXT and XML

  B. DSX and CSV

  C. DSX and XML

  D. TXT and CSV

  Correct Answer: C

• Question 14:

  In DataStage, Table Definitions can be imported through __________.

  A. DataStage Administrator

  B. Information Server Web Console

  C. DataStage Designer

  D. DataStage Director

  Correct Answer: C

• Question 15:

  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?

  A. To bring runtime information about DataStage jobs into the Metadata Repository

  B. To bring FastTrack mapping specifications into the Metadata Repository

  C. To bring Cognos BI reports and queries into the Metadata Repository

  D. To bring a blueprint from Blueprint Director into the Metadata Repository

  Correct Answer: C

• Question 16:

  What is a supported function of the Dataset Management Utility?

  A. Repartitions datasets

  B. Stores datasets

  C. Copies, views and deletes the dataset

  D. Saves the table definition for the dataset

  Correct Answer: C

• Question 17:

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

  A. Parallel Jobs

  B. Table Definitions

  C. Logs

  D. Sequence Jobs

  Correct Answer: C

• Question 18:

  Which of the following statements about FastTrack is incorrect?

  A. The only way to combine data in a FastTrack mapping specification is to create a lookup definition

  B. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems

  C. When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)

  D. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations

  Correct Answer: A

• Question 19:

  InfoSphere Data Architect is not part of the Information Server Suite. Which statement about sharing metadata with the Metadata Repository is correct?

  A. Metadata CANNOT be imported into the Metadata Repository from Data Architect

  B. Only a physical model can be exported from Data Architect to the Metadata Repository

  C. Only a logical model can be exported from Data Architect to the Metadata Repository

  D. Both, a physical model and a logical model can be exported from Data Architect to the Metadata Repository

  Correct Answer: D

• Question 20:

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

  A. In directory and file names

  B. In constraints and file names

  C. In constraints and derivations

  D. All of the above

  Correct Answer: D