Cause all that matters here is passing the IBM C2090-305 exam. Cause all that you need is a high score of C2090-305 IBM InfoSphere Information Analyzer v9.1 exam. The only one thing you need to do is downloading Exambible C2090-305 exam study guides now. We will not let you down with our money-back guarantee.


♥♥ 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. 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: A 

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


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


Q13. 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: A 


Q14. 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: A 


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


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


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


Q18. 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) 


Q19. 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: A,E 

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


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