C2090-305 33Q&S IBM InfoSphere Information Analyzer v9.1 by elin

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. 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.
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. 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.
D. 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.

Answer Clike
Which statement identifies one of the actions you need to perform before you can access the DataStage Director?

A. Perform Credential mapping.
B. Nothing is required because it is done automatically at setup.
C. There is no relationship between DataStage Director and Information Analyzer.
D. Configure in Information Analyzer Home > Configure > Setup DataStage Director.

Answer Clike
What column analysis process will infer a data class for each column in your data making it easier to compare domains of data?

A. Table analysis
B. Domain analysis
C. Baseline analysis
D. Data Classification analysis

Answer Clike
Where can the Confidence Benchmark be set?

A. Data Rule
B. Data Rule Set
C. Data Rule Group
D. Data Rule Definition

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

A. Information Analyzer User
B. Common Metadata Importer
C. Information Analyzer Data Administrator
D. Information Analyzer Project Administrator

Answer Clike
While reviewing results of a data rule test, you find a logic error. Which option will allow you to troubleshoot this error?

A. Submit test job with debug option and review the log.
B. Create a CAS log view, rerun the rule, and review the log.
C. Open client command window, submit job, and review the log.
D. Set Retain Scripts on and review job log with DataStage Director.

Answer Clike
Which can be done in the Data Rule Stage?

A. Create a metric
B. Unpublish a rule
C. Delete a published rule
D. Create an unpublished rule

Answer Clike
What are the three domain analysis methods?

A. Value, range, completeness
B. Value, range, reference table
C. Format, range, reference table
D. Value, pattern, reference table

Answer Clike
What are three of the analytical functions used in column analysis?

A. data type, domain, selectivity
B. baseline, domain, valid values
C. completeness, domain, format
D. completeness, metrics, foreign key

Answer Clike
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 <> location_number
B. master_catalog_primary_shipping_location NOT match location_number
C. master_catalog_primary_shipping_location NOT in_reference_list location_number
D. master_catalog_primary_shipping_location NOT in_reference_column location_number

Answer Clike
You need to capture the results of a data rules execution so it can be used in subsequent data rules. Which approach will work?

A. When defining Output from the data rule, select System Table Only on the output tab, name your table, and select "Overwrite" for update method.
B. When defining Output from the data rule, select Simple User-Named table on the output tab, name your table, and select "Overwrite" for update method.
C. Export system generated table from Information Analyzer Database, load the export into the Information Server repository, and select "Import" for the update method.
D. When defining Output from the data rule, select ODBC DSN from drop down list for the target database for the results, name your table, and select "Overwrite" for update method.

Answer Clike
When working with Information Analyzer reports, which two functions require use of the reporting functionality in the Information Server Web Console?

A. Add the report to Favorites.
B. Grant access to a report result.
C. Run reports without saving them
D. Create user-defined folders for reports.
E. Run reports created in the Web Console.

Answer Clike
Which two components must you identify when building a data connection in Information Analyzer?

A. table
B. schema
C. connector
D. connection string
E. path to database client library

Answer Clike
What are two characteristics of data rules?

A. Each data rule has a defined state.
B. Data rules only produce exception data.
C. Data rule definitions are explicit to one data source.
D. You cannot transfer data rules to another environment.
E. Data rules can be tested interactively during data rule creation.

Answer Clike
You have been tasked with documenting all fields that contain personal information while performing profiling activities.
Which method would you use to accomplish this?


A. Select the 'Personal' status on the Domain & Completeness workspace.
B. Update the 'Priority' attribute for each data field containing personal information.
C. Update the 'Personal' attribute for each data field containing personal information.
D. Select the data class or sub-class indicating the type of information for each field containing personal information.

Answer Clike
Which statement about published data rules is correct?

A. Published data rule definitions are linked to local rules.
B. Published data rule definitions are copies of the local rules.
C. Local data rule definitions that are modified impact published rule definitions.
D. Published data rule set definitions that are modified impact local rule set definitions.

Answer Clike
You are evaluating a Price column in an DB2 database and need to identify whether the lowest value in the column is less than 10.00. What steps are needed to evaluate this condition?

A. Create a rule definition: min(Price) < 10.00; Save; Create data rule and bind Price to the DB2 table's column.
B. Create a rule definition: minimum(Price) < 10.00; Save; Create data rule and bind Price to the DB2 table's column.
C. Create a rule definition: Price < 10.00; Save; Create data rule and bind Price to the DB2 table's column; Set Database function to minimum.
D. Create a rule definition: min(Price) < 10.00; Save; Create data rule and bind Price to the DB2 table's column; Set Database Options to DB2.

Answer Clike
Which statement is NOT true for the installation of Information Analyzer?

A. You must create the Information Analyzer database after installation.
B. You may create the Information Server repository before installation.
C. You may create the Information Server repository and Information Analyzer database before installation.
D. The Information Analyzer database and Information Server repository are created during installation.

Answer Clike
Which two are NOT valid connectors in Information Analyzer?

A. DB2 Connector
B. ODBC Connector
C. Oracle Connector (v11)
D. Informix Connector
E. SQL Server Connector

Answer Clike
What steps are required to start working with data rules?

A. Navigate in the console to the Home menu and select My Rules.
B. Navigate in the console to the Develop menu and select Data Quality.
C. Navigate in the console to the Investigate menu and select Data Rules.
D. Navigate in the console to the Data Quality menu and select Data Rules

Answer Clike
Which is NOT a defined metadata workspace within Information Analyzer?

A. Terms
B. Policies
C. User Classes
D. Data Programs

Answer Clike
What are two properties of global logical variables?

A. Cannot be changed once created
B. Can be reused by other rule definitions
C. Need rebinding when generating a data rule
D. Hold parameters which are valid system wide E. Cannot be bound to a physical source column

Answer Clike
When viewing Column Analysis Summary information, a comment will be indicated by which of the following?

A. 'Note' icon
B. 'Red flag' icon
C. 'Green check' icon
D. 'Yellow question mark' icon

Answer Clike
Which output format supports encryption and password protection of the report?

A. XLS
B. PDF
C. HTML
D. Cognos Framework Manager

Answer Clike
You are analyzing a historical data source with 500 million records with approximately 15 million added per year. You wish to analyze only records from the year 2000. The table contains a numeric field called YearAdded.
What steps will allow you to minimize the data analyzed?


A. Create Virtual Table; Set Where clause to YearAdded= 2000; Select Virtual Table; Run Column Analysis.
B. Select Table; Run Column Analysis; Select Analysis Settings tab; Set Where clause to YearAdded= 2000.
C. Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample Type to Sequential and Sample Size to 15.000.000.
D. Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample Type to Random. Sample Interval to First, and Sample Size to 15.000.000.

Answer Clike
A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country (100=Germany, 101=France. 102=ltaly, and so on). Which rule logic would address a requirement to find all French customers that have a phone number made up of ten digits?

A. countryname = 'France' AND phone matches_regexp '99.99.99.99.99'
B. lookup(countryname) = 'France' AND phone matches_regexp '99.99.99.99.99'
C. IF lookup(countryname) = 'France' THEN phone matches_format '99.99.99.99.99'
D. IF lookup(country. countrycodes. countrynames) = 'France' THEN phone matches_format '99.99.99.99.99'

Answer Clike
Given that a rule set contains two data rules that use the same variables, which statement is true?

A. Variable names must be unique.
B. A rule set can not contain more than one data rule.
C. Variable names can be the same and can be bound to different input columns.
D. Variable names can be the same but must be bound to the same input column.

Answer Clike
At which levels can Information Analyzer analysis settings be set?

A. Host Project, Table. Column
B. System, Host, Database, Table
C. System. Project. Table. Column
D. Project. Database. Column. Property

Answer Clike
You need to check multiple columns for duplicates. How does changing the column sequence in Run Duplicate Analysis affect the duplicate check analysis results?

A. It has no effect on the results.
B. It may result in more duplicates.
C. It may result in fewer duplicates.
D. You can only run duplicate check analysis on single columns.

Answer Clike