Ucertify offers free demo for C2090-305 exam. "IBM InfoSphere Information Analyzer v9.1", also known as C2090-305 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-305 exam, will help you answer those questions. The C2090-305 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-305 exams and revised by experts!
♥♥ 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. Which two techniques can be used to improve performance when processing large flat files?
A. Use virtual tables.
B. Place an index on the file.
C. Increase the metadata repository size.
D. Change the ODBC driver from text driver to parallel driver.
E. Modify the DataStage APT config file to parallel process the data.
Answer: B,D
Q22. What are the three domain analysis methods?
A. Value, range, completeness
B. Value, range, reference table
C. Format, range, reference table
D. Value, pattern, reference table
Answer: B
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 82)
Q23. You are searching for an employee named Kristie Jones who has accounts on various applications, in which she has used the first names Kristie, Kristin, and Kristen as her first name.
Which is the correct rule logic for addressing this problem?
A. name like ('KristieTKristinTKristen')[ ]'Jones'
B. name matches (,KristieTKristinTKristen,)[]'Jones,
C. name contains ('KristieTKristinTKristen'^rJones'
D. name matches_regex ('Kristie'l'KristinTKristen^j'Jones'
Answer: D
Q24. Which two components must you identify when building a data connection in Information Analyzer?
A. table
B. schema
C. connector
D. connection string
E. path to database client library
Answer: D,E
Q25. If there is a need to run data rules on a daily basis, which two options are valid?
A. Create a bundle and run lAJob command
B. Schedule lAJob runs using DataStage Director
C. Run lAJob command pointing to data rule executable
D. Run lABundle command pointing to all rules to be executed
E. Submit lAJob command on a daily basis from Information Server Operation console
Answer: C,E
Q26. Which of the following will allow you to run a data rule without using the Information Analyzer graphical user interface?
A. Tivoli
B. HTTP API
C. Federation Server
D. Information Services Director
Answer: B
Q27. 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: D
Q28. 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
Q29. In which two screens can you see the output results of the data quality rules?
A. Data Studio
B. Project Dashboard
C. DataStage Director
D. Information Services Director
E. Information Analyzer My Home workspace
Answer: B,E
Q30. Which two statements are relevant to key analysis in Information Analyzer?
A. The discovery of data objects
B. The functional dependencies of two columns in a table
C. Determining the suitability of data values found in a table
D. The confirmation or identification of a primary key for a table
E. Given a primary key, performing a duplicate check of primary key values in the table
Answer: D,E