IBM InfoSphere Information Analyzer v9.1 (C2090-305) Free Practice Test

Question 1

You are analyzing a known table with a five column primary key. You wish to confirm its uniqueness with minimal processing time.
Which steps should you take?

A. Create a Virtual Table including only the five columns, select the Virtual Table and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 1. Review Primary Key Analysis on the Multi-column tab.

B. Select only the five columns and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 5. Review Primary Key Analysis on the Multi-column tab.

C. Select only the five columns and run Multi-column Primary Key Analysis with Multi-column option = Concatenate. Review Primary Key Analysis on the Multi-column tab.

D. Create a Virtual Column including only the five columns, select the Virtual Column and run Column Analysis. Review Primary Key Analysis for the Virtual Column on the Single column tab.

Correct Answer: C

Question 2

When creating a data rule definition through the HTTP API, which two can be included as attributes of the <DataRuleDefinition> element?

A. <Folder>

B. <Policy>

C. <Name>

D. <ExecutabIeRules>

E. <Description>

Correct Answer: B,C

Question 3

To import metadata into Information Analyzer, a user requires which Information Server role as a minimum?

A. Information Analyzer Project Administrator

B. Common Metadata Importer

C. Information Analyzer User

D. Information Analyzer Data Administrator

Correct Answer: B

Question 4

The DSN for the Information Analyzer database needs to be created on which tier?

A. Services

B. Engine

C. Workbench

D. Database

Correct Answer: D

Question 5

Which is NOT a defined metadata workspace within Information Analyzer?

A. Data Programs

B. User Classes

C. Terms

D. Policies

Correct Answer: C

Question 6

It is desired to create a data rule to determine how many rows in the master data catalog have a primary shipping location that is not found in the location_number column in the "Location" table.
What is the proper rule definition logic to achieve this requirement?

A. master_catalog_primary_shipping_location NOT match location_number

B. master_catalog_primary_shipping_location NOT in_reference_list location_number

C. master_catalog_primary_shipping_location NOT in_reference_column location_number

D. master_catalog_primary_shipping_Iocation <> location_number

Correct Answer: D

Question 7

You suspect that data in a table contains inconsistent structure/formatting. Which
Information Analyzer Column Analysis screen would be used to determine this?

A. Tokens

B. Layout

C. Format

D. Structure

Correct Answer: D

Welcome to TestSimulate

IBM InfoSphere Information Analyzer v9.1 (C2090-305) Free Practice Test