[Free] 2017(Oct) CollectDumps Passguide IBM C2090-305 V13 Dumps with VCE and PDF Download 1-10

CollectDumps 2017 Oct IBM Official New Released C2090-305 V13
100% Free Download! 100% Pass Guaranteed!
http://www.CollectDumps.com/C2090-305 V13.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% Free Download!
Download Free Demo:C2090-305 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 CollectDumps C2090-305 V13 Full Exam PDF and VCE

CollectDumps 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

2017 CollectDumps IT Certification PDF and VCE