Exam Code: C2090-305 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere Information Analyzer v9.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-305 Exam.
2021 Apr C2090-305 Study Guide Questions:
Q21. Which analysis would be used to identify whether a column with a "character" data type contains null values?
A. Format
B. Precision
C. Cardinality
D. Classification
Answer: A
Q22. 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
Q23. 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
Up to date C2090-305 free download:
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: D
Q25. 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
Q26. You are implementing a rule that evaluates the valid values for an Indicator field. What steps are necessary to tolerate a 1 % error rate in the executed rule?
A. Open Data Rule workspace; on Overview tab, set Baseline Comparison Benchmark to % Not Met <= 1.0000%
B. Open Data Rule workspace; on Overview tab, set Validity Benchmark to % Not Met <= 1.0000%
C. Open Data Rule workspace; on Overview tab, set Confidence Benchmark to % Not Met <= 1.0000%
D. Open Data Rule workspace; on Bindings & Output tab. select Output View, set Baseline to % Not Met <= 1.0000%
Answer: B
High value C2090-305 training materials:
Q27. 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
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. 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
Q30. How many Information Analyzer databases can a single installation have?
A. There can only be one Information Analyzer database.
B. There can be more than one Information Analyzer database, with no restriction on tier location.
C. There can be more than one Information Analyzer database, as long as all of them are on the same computer as the engine tier.
D. There can be more than one Information Analyzer database, as long as all of them are on the same computer as the repository tier.
Answer: A