Questions and Answers:111 Q&As
Updated: 2009-08-31
Exam Number/Code: 000-417
Exam Name: IBM WebSphere Information Analyzer v8.0
IBM IBM certifications I 000-417 111Q&As are created by senior IT lecturers in Certinside certification Q&A network and IBM certifications I product experts combination PROMETRIC or VUE true-to-date environmental examination of the original title.
The Questions & Answers cover the latest real test and with all the correct answer.we promise the Q&A for IBM certifications I 000-417(IBM WebSphere Information Analyzer v8.0) examination of original title complete coverage.000-417 Questions & Answers help you pass the exam.
000-417 Free Demo Download
Certinside offers free demo for 000-417 111 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.
Download 000-417 Exam Pdf Demo
Download 000-417 Exam iEngine Demo
Exam : IBM 000-417
Title : IBM WebSphere Information Analyzer v8.0
1. You are installing Information Analyzer and plan to use DB2 as the analysis database, which statement is true?
A. The analysis database is automatically created at installation.
B. You must install the analysis database after you install the suite.
C. The analysis database DSN is automatically created at installation.
D. You must configure the analysis database before you install the suite.
Answer: A
2. When planning a data quality assessment project, application owners have expressed reluctance to provide real-time access to their source systems using Information Analyzer.
Which two concepts should be discussed and understood by the assessment team? (Choose two.)
A. data standardization needed
B. data transformation rules needed
C. timeliness of data and its effect on structural metadata
D. timeliness of data and its effect on data assessment results
Answer: CD
3. A company has determined a need for profiling a centralized data warehouse for business intelligence reporting.
During the initial client discovery session, which three initial questions should be addressed? (Choose three.)
A. Which data marts are generated?
B. Which data sources are contributors?
C. Which underlying issues are suspected?
D. Which users are subject matter experts?
E. Which are the referential integrity violations?
Answer: BCD
4. For a data quality assessment project, which three roles are involved throughout the assessment? (Choose three.)
A. data modeler
B. data analyst
C. ETL developer
D. business analyst
E. business subject matter expert
Answer: BDE
5. Which statement is true with regards to publishing analysis results?
A. Reference tables can be created then published and accessed using QualityStage.
B. Categories can be created then published and accessed using Business Glossary.
C. The accepted primary and foreign keys can be published then accessed using DataStage.
D. The candidate primary and foreign keys can be published then accessed using Business Glossary.
Answer: C
6. What are two valid ways of connecting AuditStage to a database? (Choose two.)
A. JDBC
B. federation
C. Information Analyzer
D. direct database connection
Answer: BD
7. Which two connectors are automatically available when defining a data source to Information Analyzer? (Choose two.)
A. ODBCConnector
B. JDBCConnector
C. DataStageConnector
D. WebSphereMQConnector
Answer: AD
8. Which two roles must be assigned to a user to complete the configuration of Information Analyzer? (Choose two.)
A. data administrator
B. project administrator
C. database administrator
D. production administrator
Answer: AB
9. Which analysis builds a complete set of all the column pairs between primary key columns and remaining selected columns in selected tables?
A. column analysis
B. foreign key analysis
C. cross table analysis
D. primary key analysis
Answer: B
10. What must be installed prior to AuditStage?
A. .NET Framework
B. Information Server
C. Java Run-time Environment
D. Microsoft Data Access Components
Answer: D
11. Given a review of a new column analysis, which review processes must be completed in sequence?
A. domain analysis, then format analysis
B. format analysis, then properties analysis
C. domain analysis, then rebuild inferences
D. properties analysis, then classification analysis
Answer: C
12. Which three methods can be used to review the results of domain analysis? (Choose three.)
A. Examine each value individually.
B. Specify a range to determine the validity of the values.
C. Compare all of the values to the values in a reference table.
D. Specify a conditional test to determine the validity of the values.
E. Create an automated script to check the validity of values based on business requirements.
Answer: ABC