Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-305
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-305.html

IBM InfoSphere Information Analyzer v9.1

Question No: 1

A company is starting an Information Analysis project to assess the data quality of Key Performance Indicators (KPIs). They also want to setup on-going monitoring of the data quality and have no tolerance for error.

Which two statements are true when considering what data to analyze?

  1. Sample the source data.

  2. Analyze all rows in the source data.

  3. Analyze all columns in the source data.

  4. Analyze only those columns that support the KPIs.

  5. Create a virtual column containing only those columns that support the KPIs.

Answer: A,D

Question No: 2

Which rule definition logic will ensure that no value in a column appears more than three times in the data?

  1. testvalue EXISTS lt;= 3

  2. testvalue OCCURS lt;= 3

  3. testvalue APPEARS lt;= 3

  4. testvalue CONTAINS lt;= 3

Answer: D

Question No: 3

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

  1. #39;Note#39;icon

  2. #39;Red flag#39; icon

  3. #39;Green check#39; icon

  4. #39;Yellow question mark#39; icon

Answer: A

Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer- v8-7-User-guide(page 88)

Question No: 4

What are the three domain analysis methods?

  1. Value, range, completeness

  2. Value, range, reference table

  3. Format, range, reference table

  4. Value, pattern, reference table

Answer: B

Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer- v8-7-User-guide(page 82)

Question No: 5

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

  1. It has no effect on the results.

  2. It may result in more duplicates.

  3. It may result in fewer duplicates.

  4. You can only run duplicate check analysis on single columns.

Answer: A

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ia.faq.doc/topics/ ia_faq_running_table_analysis.html?cp=SSZJPZ_11.3.0/12-15-1-1-3

Question No: 6

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

  1. When defining Output from the data rule, select System Table Only on the output tab, name your table, and select quot;Overwritequot; for update method.

  2. When defining Output from the data rule, select Simple User-Named table on the output tab, name your table, and select quot;Overwritequot; for update method.

  3. Export system generated table from Information Analyzer Database, load the export into the Information Server repository, and select quot;Importquot; for the update method.

  4. 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 quot;Overwritequot; for update method.

Answer: C

Question No: 7

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

  1. Ensure only binary values; Evaluate skews in frequency; Ensure no special characters.

  2. Ensure no null values; Evaluate skews in frequency; Ensure consistency in format.

  3. Ensure no skews in frequency; Ensure only numeric values; Evaluate as a primary key.

  4. Ensure all unique values; Evaluate out-of-range in frequency; Ensure consistency in format.

Answer: A

Question No: 8

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?

  1. Open InfoSphere Metadata Asset Manager; go to Homegt;Metadata Managementgt;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.

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

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

  4. 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 No: 9

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

  1. You must create the Information Analyzer database after installation.

  2. You may create the Information Server repository before installation.

  3. You may create the Information Server repository and Information Analyzer database before installation.

  4. The Information Analyzer database and Information Server repository are created during installation.

Answer: C

Question No: 10

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

  1. Use virtual tables.

  2. Place an index on the file.

  3. Increase the metadata repository size.

  4. Change the ODBC driver from text driver to parallel driver.

  5. Modify the DataStage APT config file to parallel process the data.

Answer: B,D

100% Ensurepass Free Download!
Download Free Demo:C2090-305 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-305 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.