Realistic of C2090-305 exam engine materials and tutorials for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-305 pdf dumps vce Materials. 100% PASS IBM InfoSphere Information Analyzer v9.1 exam Today!


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

Q31. You are working with a database administrator (DBA) who would like to create a revised 

format for a database based on your data profiling results. The DBA wants to directly create the resulting tables from the analysis. 

What steps are necessary to provide usable output to the DBA? 

A. Select lnvestigate>Publish Analysis Results; select the relevant Table; select Generate Physical Model; select Create DDL File option; enter file location; click Submit. 

B. Select lnvestigate>Column Analysis; select the relevant Table; select Export Data Model; select Create ANSI Standard DDL option; enter file location; click Submit. 

C. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the Generate Database DDL option; select the database-specific DDL type; enter file location; click Submit. 

D. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the InfoSphere Metadata Asset Manager option; click Submit; create New Import Area; select the InfoSphere Data Architect Metabroker; select the created PDR model; select generate ANSI standard DDL; click Submit. 

Answer: B 


Q32. A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country (100=Germany, 101=France. 102=ltaly, and so on). 

Which rule logic would address a requirement to find all French customers that have a phone number made up often digits? 

A. countryname = 'France' AND phone matches_regexp '99.99.99.99.99' 

B. lookup(countryname) = 'France' AND phone matches_regexp '99.99.99.99.99' 

C. IF lookup(countryname) = 'France' THEN phone matches_format '99.99.99.99.99' 

D. IF lookup(country. countrycodes. countrynames) = 'France' THEN phone matches_format '99.99.99.99.99' 

Answer: D 


Q33. You are analyzing a historical data source with 500 million records with approximately 15 million added per year. 

You wish to analyze only records from the year 2000. The table contains a numeric field called YearAdded. 

What steps will allow you to minimize the data analyzed? 

A. Create Virtual Table; Set Where clause to YearAdded= 2000; Select Virtual Table; Run Column Analysis. 

B. Select Table; Run Column Analysis; Select Analysis Settings tab; Set Where clause to YearAdded= 2000. 

C. Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample Type to Sequential and Sample Size to 15.000.000. 

D. Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample Type to Random. Sample Interval to First, and Sample Size to 15.000.000. 

Answer: D 


Q34. Given that a rule set contains two data rules that use the same variables, which statement is true? 

A. Variable names must be unique. 

B. A rule set can not contain more than one data rule. 

C. Variable names can be the same and can be bound to different input columns. 

D. Variable names can be the same but must be bound to the same input column. 

Answer: A 


Q35. Which two can be used to identify exception descriptors of interest in the Data Quality Console? 

A. View rule definitions on the Data Quality tab 

B. View exception descriptors on the Home page 

C. Use the search criteria on the Exceptions page 

D. View exception descriptors on the Data Rule Execution History page 

E. View rule exceptions on the All Quality Controls chart on the Home page 

Answer: B,C 

Reference:http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.dqc.ug.doc/topic s/t_tracking_exceptions.html(see procedure) 


Q36. Which output format supports encryption and password protection of the report? 

A. XLS B. PDF 

C. HTML 

D. Cognos Framework Manager 

Answer: B 


Q37. The DSN for the Information Analyzer database needs to be created on which tier? 

A. Engine 

B. Services 

C. Database 

D. Workbench 

Answer: A 

Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 17, table 1, 3rdrow, second column) 


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