Free IBM 000-N10 Exam Dumps Questions & Answers

In Business Glossary, you have defined a term named "Product Brand". The names of these product brands are in an operational database table named BRANDS. Some of these brands are not valid. What would be the best way to enable BG users to see an up-to-date list of valid product brands?

• A.Create a reference table of valid brands with Information Analyzer. Then, in Business Glossary, create a custom attribute named VALIDBRANDS, and write the values of the valid brands, using the reference table data. Associate the custom attribute with the term "Product Brand".
• B.Create a new table VALIDBRANDS in the operational database, and copy only the valid values in that table. Then, in Business Glossary, associate the term "Product Brand" with the table VALIDBRANDS.
• C.In Business Glossary, associate the term "Product Brand" with the table BRANDS
• D.Create a reference table of valid brands with Information Analyzer. Create a service which returns the list of valid brands from the reference table. Then, in Business glossary, invoke the service from a custom attribute named VALIDBRANDS, and associate this attribute with the term "Product Brand".

You have installed Information Analyzer. Which of the following statements is TRUE?

• A.The analysis database is automatically created during installation.
• B.The analysis database can only be installed after the installation of the Information Server suite.
• C.The analysis database can only be created before installing the Information Server suite.
• D.The analysis database is part of the Information Server Metadata Repository.

What are the advantages of DataStage parallel jobs?

• A.Scalable processing and restartable processing
• B.Parallel processing and multi-pass processing
• C.Multi-pass processing and scalable processing
• D.Parallel processing and scalable processing

A table is populated through a stored procedure reading data from 3 files, and transforms the data before inserting it into a DB2 table. Using Metadata Workbench, the data lineage report shows the data flow from a BI report back to the DB2 source table. Could the data flow be traced back to the 3 files?

• A.No, because the transformation from the 3 files to the DB2 table is not done via a DataStage job.
• B.Yes, but it requires the Metadata Workbench Administrator to create an extended mapping document, which contains mapping rows between the source files and the DB2 table along with the business rules used to perform the transformations. The data lineage diagram will contain an extended mapping icon linked to the table and files.
• C.Yes, all the metadata related to the stored procedure can be imported into the Metadata Server using MetaBrokers and Bridges (Import/Export Manager). The data lineage diagram will contain a stored procedure icon linked to the table and files.
• D.Yes, the Metadata Workbench administrator just needs to run the automated services.

Which statement about the InfoSphere Data Architect installation is CORRECT?

• A.InfoSphere Data Architect can be installed as part of InfoSphere Information Server.
• B.To be able to import / export data models from InfoSphere Data Architect to modeling tools such as Erwin or Sybase Power designer, themodel import / export feature must be selected during installation.
• C.InfoSphere Data Architect must be installed before InfoSphere Information Server.
• D.InfoSphere Data Architect must be installed after InfoSphere Information Server.