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 Testking 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

Q21. 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:


Q22. 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:


Q23. 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:

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


Q24. You have been tasked with documenting all fields that contain personal information while performing profiling activities. 

Which method would you use to accomplish this? 

A. Select the 'Personal' status on the Domain & Completeness workspace. 

B. Update the 'Priority' attribute for each data field containing personal information. 

C. Update the 'Personal' attribute for each data field containing personal information. 

D. Select the data class or sub-class indicating the type of information for each field containing personal information. 

Answer:


Q25. 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:


Q26. 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:


Q27. 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:


Q28. 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:

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 


Q29. 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:


Q30. 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? 

A. Sample the source data. 

B. Analyze all rows in the source data. 

C. Analyze all columns in the source data. 

D. Analyze only those columns that support the KPIs. 

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

Answer: A,D