C2090-305 Exam - Free IBM Questions and Answers

Question #6 (Topic: )

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: C

Question #7 (Topic: )

You are evaluating a Date of Birth field in a customer table. What are the three key steps in
analyzing this field?

A. Ensure only binary values; Evaluate skews in frequency; Ensure no special characters. B. Ensure no null values; Evaluate skews in frequency; Ensure consistency in format. C. Ensure no skews in frequency; Ensure only numeric values; Evaluate as a primary key. D. Ensure all unique values; Evaluate out-of-range in frequency; Ensure consistency in format.

Answer: A

Question #8 (Topic: )

A new business group, working in a separate and distinct Information Analyzer
environment, is starting to assess their data quality, but wishes to reuse existing data
quality validation to jumpstart their effort.
Which method supports delivering the data rule definitions to this new environment?

A. Open InfoSphere Metadata Asset Manager; go to Home>Metadata Management>Data Quality, select the desired Data Rule Definitions, click the Export task, and then provide the output file name. Repeat the process in the new environment but click the Import option and select the output file name. B. Open InfoSphere Metadata Workbench; go to the Find tab; open drop down list and select Data Rule Definition; check the desired Data Rule Definitions; click Save icon and select Save as Data Format(XML) - Import. Open Metadata Workbench in the new environment but click the Advanced tab; select Import Metadata option and select the output file name. C. Create an Information Analyzer command line (CLI) request to -getRuleDefinition including the -project parameter, the -ruleName parameter with each rule separated by a comma, and the -xml output type parameter, and the -output parameter with the output file name. In the new environment create the command line (CLI) request to import the output file name. D. Create an Information Analyzer command line (CLI) request to -exportRuleDefinitions including the -project parameter, the -ruleName parameter with each rule separated by a comma, the -xml output type parameter, and the -output parameter with the output file name. In the new environment create the command line (CLI) request to import the output file name.

Answer: C

Question #9 (Topic: )

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: C

Question #10 (Topic: )

Which two techniques can be used to improve performance when processing large flat
files?

A. Use virtual tables. B. Place an index on the file. C. Increase the metadata repository size. D. Change the ODBC driver from text driver to parallel driver. E. Modify the DataStage APT config file to parallel process the data.

Answer: B,D

IBM C2090-305 - IBM InfoSphere Information Analyzer v9.1 Exam