It is impossible to pass IBM C2090-305 exam without any help in the short term. Come to Testking soon and find the most advanced, correct and guaranteed IBM C2090-305 practice questions. You will get a surprising result by our Refresh IBM InfoSphere Information Analyzer v9.1 practice guides.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-305 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-305 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-305-exam-dumps.html
Q11. 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: 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%2F12-15-1-1-3
Q12. 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
Q13. When creating a data rule definition through the HTTP API, which two can be included as attributes of the <DataRuleDefinition> element?
A. <Name>
B. <Policy>
C. <Folder>
D. <Description>
E. <ExecutableRules>
Answer: A,D
Q14. You suspect that data in a table contains inconsistent structure/formatting. Which
Information Analyzer Column Analysis screen would be used to determine this?
A. Layout
B. Format
C. Tokens
D. Structure
Answer: D
Q15. You have a Quantity field with the precision of two and it cannot have a negative or zero value. What steps can be taken to identify the Invalid values?
A. Open Format tab; Set Format Mask to +0.00; Click Apply Format Mask; Save
B. Open Domain & Completeness tab; Set Domain Type to Range; Enter Minimum value of 0.01; Click Reload; Save
C. Open Domain & Completeness tab; Set Domain Type to Range; Enter Maximum value of 0.00; Click Reload; Save
D. Open Domain & Completeness tab; Set Domain Type to Value; Enter Minimum value of 0.00; Select Invalid radio button; Click Reload; Save
Answer: C
Q16. You are configuring security for a user who will be testing Information Analyzer rules on an ad hoc basis.
What steps are necessary to ensure the user can test the rules?
A. Enable the Suite User and Information Analyzer Rules Author roles in the Information Server web console on the Administration tab.
B. Enable the Rules User role in the Information Analyzer console Project Properties workspace. Add the Data Operator role in the Information Analyzer console Project Properties workspace.
C. Enable the Rule User role in the Information Analyzer console Project Properties workspace. Add the Rules Operator role in the Information Analyzer console in the Home Analysis Settings workspace.
D. Enable the Suite User and Rules Administrator role in the Information Analyzer web console on the Administration tab. Add the Data Operator role in the Information Analyzer console Project Properties workspace.
Answer: A
Q17. You are working with a System Administrator who must move an Information Analyzer project to a new Information Server environment using the command line tools. You need to ensure that the project is established with the same metadata and reports as in the original environment.
Which parameter must be included to successfully complete the export?
A. -includeCommonMetadata; -includeCommonReports; -includeAIIDataClasses
B. -includeAssignedAssets; -includeProjectReports; -includeAIIDataSources
C. -includeCommonMetadata; -includeReports; -includeAIIDataClasses
D. -includeProjectMetadata; -includelAReports; -includeDependentClasses
Answer: D
Q18. What feature permits the addition of data from one or more columns into one column allowing column analysis on this newly formed concatenated column?
A. Virtual table
B. Logical table
C. Virtual column
D. Logical column
Answer: C
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 70)
Q19. 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: C
Q20. You are reviewing the summary of a data rule on the Information Analyzer Home Page dashboard and see a red exclamation mark.
What does it signify?
A. The data rule was run via an external scheduler.
B. The job for the data rule failed to run successfully.
C. The data rule result was not delivered to the Data Quality Console.
D. The data rule failed to meet the target benchmark for two or more instances.
Answer: B
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(p. 190, last para of the page)