IBM InfoSphere Information Server Technical Mastery v2 Set 1

Question - 15 Maximum mark : - 28

Home
All Exams
IBM InfoSphere Information Server Technical Mastery v2 Online Practice Exams
IBM InfoSphere Information Server Technical Mastery v2 Set 1

Which tool would you recommend to obtain a clear roadmap of the tasks required to deal with quality issues of data stored in your source databases?

Use the native DBMS catalog tables, and retrieve the detailed statistics ✘ InfoSphere Metadata Workbench ✘ InfoSphere Information Analyzer ✘ InfoSphere Blueprint Director ✔ InfoSphere Discovery ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

There is a need to create a new business term in the business glossary. This can be done by a user having which user role and using which interface of InfoSphere Business Glossary?

A user with the Business Glossary administrator role, using the Business Glossary Browser interface ✘ A user with the Business Glossary author role, using the Business Glossary client for Eclipse ✘ A user with the Business Glossary author role, using an application developed with the Businessglossary REST API, allowing business terms to be created ✘ A user with Business Glossary user role, using the administrative interface of Business Glossary(Information Server Web Console) ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement about FastTrack mapping editor is TRUE?

Each transformation rule description field must be filled before a job can be generated. ✘ The transformation rule expression field does not need to be filled for each pair of mapped columnsbefore a job can be generated. ✘ Each transformation rule expression must contain valid SQL syntax. ✘ The annotation field contains information about errors encountered during validation of a mappingspecification. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

In Business Glossary, associate the term "Product Brand" with the table BRANDS ✘ Create a new table VALIDBRANDS in the operational database, and copy only the valid values in thattable. Then, in Business Glossary, associate the term "Product Brand" with the table VALIDBRANDS. ✘ Create a reference table of valid brands with Information Analyzer. Then, in Business Glossary, createa 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". ✘ Create a reference table of valid brands with Information Analyzer. Create a service which returns thelist 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". ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

The analysis database is automatically created during installation. ✘ The analysis database is part of the Information Server Metadata Repository. ✘ The analysis database can only be installed after the installation of the Information Server suite. ✘ The analysis database can only be created before installing the Information Server suite. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Multiple steps or tasks are performed when analyzing the data with InfoSphere Discovery. Which of the following statements is accurate?

Transformations are discovered during the execution of the Maps step. ✘ Running a step (column analysis, PF keys, Maps) results in the execution of one or more DataStagejobs. ✘ Changing the processing options for the PF key analysis does not impact which columns will beidentified as primary key and foreign keycolumn. ✘ Discovery will identify at most one map between two data objects. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

In a query, the criteria used for filtering the desired metadata can be based on different asset types ✘ Queries can be saved in XML format ✘ Only the administrator can create new queries ✘ Queries can report on objects that are not stored in the Metadata Repository, as long as these objectsare created by one of the InformationServer suite of products ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Regarding Metadata Workbench, which of the following statements is TRUE?

It creates business, data and operational lineage reports. ✘ It creates operational and data lineage reports. ✘ It creates business and data lineage reports. ✘ It creates architectural, data and operational lineage reports. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

When reviewing the analysis results in Information Analyzer, what does a red flag mean in the summary pane?

The analysis could not complete in the time allocated; results are based on a subset of the data. ✘ An error occurred during analysis. ✘ An anomaly was detected between the defined value and the inferred value. ✘ The column was checked by the user because it requires additional review. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which statement about FastTrack is NOT TRUE?

In a FastTrack mapping specification involving a lookup, you cannot specify a file that will contain the reject records; this must be performed using the DataStage Designer. ✘ When a job is generated from a FastTrack specification, it can contain connection information toaccess the source and the target. ✘ When generating a job from a FastTrack specification, you can specify for the source and target thestage type desired (e.g. sequential file, ODBC connector, DB2 stage) ✘ Changes in mapping specification can be propagated as annotations. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM InfoSphere Information Server Technical Mastery v2 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner