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 May C2090-305 Study Guide Questions:
Q1. Which type of analysis provides the benefit of monitoring your data over time so that you can determine whether the content and structure of your data has changed?
A. Format analysis
B. Baseline analysis
C. Data Classification analysis
D. Key and cross-domain analysis
Answer: B
Q2. 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
Q3. 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
Rebirth C2090-305 pdf exam:
Q4. What steps are required to start working with data rules?
A. Navigate in the console to the Home menu and select My Rules.
B. Navigate in the console to the Develop menu and select Data Quality.
C. Navigate in the console to the Investigate menu and select Data Rules.
D. Navigate in the console to the Data Quality menu and select Data Rules
Answer: B
Q5. Which of the following is the correct HTTP API request format for creating a data rule definition in an existing project?
A. http://<ServerName>:9080/lnformationAnalyzer/post?ruleDefinition
B. http://<ServerName>:9080/InformationAnalyzer/create?projectContent
C. http://< ServerName>:9080/lnformationAnalyzer/create?ruleTaskSequence
D.
http://<ServerName>:9080/InformationAnalyzer/create?projectName=<YourProjectName> 8.ruleName= <YourRuleName>
Answer: D
Q6. What feature allows you to mark issues for further investigation and add information to highlight problems to other data analysts for both columns and tables?
A. Table creation
B. Notes creation
C. Column creation
D. Comments creation
Answer: B
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 88)
Refined C2090-305 :
Q7. 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
Q8. 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
Q9. 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: C
Q10. 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: C