business intelligence solutions v8.1 : 000-705 Exam
Test Information:
• Number of questions: 56
• Time allowed in minutes: 75
• Required passing score: 58%
Related certifications:
• IBM Certified Solution Designer — DB2 Business Intelligence V8
• IBM Certified Solution Developer — IBM Alphablox
Exam Topics Include:
• Business Intelligence Terminology, Functions and Differentiators
• Gather Customer BI Requirements
• Business Intelligence Data Sourcing/Movement
• Business Intelligence Solution Architecture
Product Description
Exam Number/Code: 000-705
Exam Name:business intelligence solutions v8.1
“business intelligence solutions v8.1″, also known as 000-705 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 112 questions to your 000-705 Exam preparation. In the 000-705 exam resources, you will cover every field and category in IBM certifications helping to ready you for your successful IBM Certification.
Exam Details
Job Role Description / Target Audience If you are knowledgeable of IBM’s Business Intelligence solutions and the fundamental concepts of DB2 Universal Database, and are capable of performing the intermediate and advanced skills required to design, develop and support Business Intelligence applications, you may benefit from this certification . This certification is applicable to those who specialize in identifying the business and technical requirements of a Business Intelligence opportunity; and consult, architect and manage Business Intelligence solutions. This is a software based test for use by consultants and implementors that is based on IBM’s Business Intelligence software and solutions. To attain the IBM Certified Solution Designer – DB2 Business Intelligence V8 certification, candidates must pass 1 tests(000-705).
Question: 1
Which of the following is the most appropriate element of Business Intelligence architecture to discuss with end users?
A. Metadata design
B. Data warehouse design
C. Visualization requirements
D. Data propagation methodology
Answer: C Question: 2
Which of the following metadata approaches facilitates the integration of tools from multiple vendors with the most flexibility?
A. Centralized API approach
B. Decentralized API approach
C. Centralized or repository approach
D. Decentralized or interchange approach
Answer: D Question: 3
Which of the following is the primary METADATA task of a data modeling tool?
A. Maintain entity relationships
B. Maintain scheduling information
C. Maintain data definition language (DDL)
D. Maintain metadata Interchange Language (MIL)
Answer: A Question: 4
Which of the following ideally determines when a data warehouse is scheduled to be updated?
A. Calendar events
B. System requirements
C. Business requirements
D. Volatility of operational data store
Answer: C Question: 5
Which of the following is a data cleansing process?
A. Summarizing data
B. Building dimensions
C. Extracting only valid data
D. Checking referential integrity
Answer: D Question: 6
A retail chain would like to do more accurate sales projections based on its large volumes of
historical sales data. It has tracked store sales, but would like to identify sales patterns and buying characteristics. Which IBM Business Intelligence product is best suited for this analysis?
A. DB2 OLAP Server
B. DB2 XML Extender
C. DB2 Spatial Extender
D. DB2 Intelligent Miner
Answer: D Question: 7
A company has recently implemented a data warehouse which consolidates data from multiple branch offices. What benefit can be realized?
A. Eliminates the need for a datamart
B. Facilitates the correction of errors at the branch office
C. Eliminates the need for branch operational system reports
D. Provides a consistent corporate view of business information
Answer: D Question: 8
Which of the following is a key benefit of storing attribute definitions as metadata?
A. Reduces overall storage requirements
B. Significantly enhances load time performance
C. Allows for bi-directional update of operational data
D. Allows data load rules to be shared across multiple tools
Answer: D Question: 9
Which of the following is the most important factor when defining an OLAP cube?
A. Number of measures
B. Number of dimensions
C. Number of source data transactions
D. Number of referential integrity constraints
Answer: B Question: 10
An international marketing executive uses an OLAP query which displays sales information by country. What is the OLAP feature that would allow the executive to breakdown the sales by city?
A. Pivot
B. Roll up
C. Drill down
D. Dynamic calculation
Answer: C Question: 11
A company mails highly detailed reports to remote users. This level of detail is only required
occasionally, but is sometimes critical. Which of the following would be a flexible method for addressing this problem?
A. Provide summarized reports downloaded using FTP
B. Create summarized and detailed templates distributed via e-mail
C. Invite collaborative input of remote users incorporating Domino
D. Implement a web-based reporting tool with drill down capabilities
Answer: D Question: 12
Which method should be used to decompose a free form product code that contains both size and color information?
A. Parsing
B. Mapping
C. Using foreign keys
D. Defining an intelligent primary key
Answer: A Question: 13
Given time series information, what is the BEST statistical technique used to forecast the next six months?
A. Trend analysis
B. Cluster analysis
C. Association analysis
D. Multidimensional analysis
Answer: A Question: 14
A client has an application that was written in-house. What is the most important factor when defining the mapping for data extraction?
A. The layout and format of the data
B. The source system network connectivity
C. The OLAP tools used to access the extracted data
D. The source system application programming language
Answer: A Question: 15
A company currently provides hard copy reports to individual end users. How could a Business
Intelligence solution satisfy the changing analysis requirements within the end user community?
A. By allowing end users to define their own metadata
B. By providing the current reports in softcopy format
C. By redesigning the report template for each end user
D. By allowing end users the flexibility to create their own reports
Answer: D
Question: 16
Given a Business Intelligence solution that measures near real-time business performance and the need to notify users when a critical metric exceeds a business threshold, the most appropriate
technique is _ .
A. push messaging
B. on-demand notification
C. frequent text report generation
D. triggers that immediately update warehouse tables
Answer: A Question: 17
A company’s current reports are highly detailed in nature but are not meeting the needs of the end users. Which of the following would be the most flexible method for addressing this problem?
A. Form a user group to determine which reports are no longer necessary
B. Implement a web-based service to deliver additional summarized reports
C. Hire business specialist consultants to produce industry standard reports
D. Implement a front-end tool which allows users to create their own summarized reports
Answer: D Question: 18
Which of the following would a business user consider to be the most important difference between DB2 OLAP and ROLAP offerings?
A. DB2 SQL offers ROLAP features
B. DB2 OLAP uses a special filing system
C. DB2 OLAP has a large number of applications which can use it
D. A DB2 OLAP system normally produces much faster speed of query response
Answer: D Question: 19
A production system generates in excess of one million transactions per day.
Which method would normally be used to manage the movement of this data to the warehouse on an hourly basis?
A. Perform full data refresh
B. Apply the net changes in the data
C. Append the summary data to the target
D. Create a mirror image of the operational tables on another system
Answer: B Question: 20
In a large warehouse environment, what method or mechanism is often used to minimize the effect of on-line disk failure?
A. Striping B. Blocking C. Mirroring
D. Double buffering
*pass4sure ibm 000-705 Questions and Answers : 112 questions
* Updated: October 2nd , 2008
* Price: $159.99 $99.99
Free down:Testking ibm 000-705
Free down:Pass4sure ibm 000-705
| IBM Free Downloads |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Ibm 's Exam Pack |
767 |
1 days ago | Download |
If you would like to make a comment, please fill out the form below.
[...] Solution Designer: Solution Designer pass4sure 000-443 Exam : DB2 Content Manager V8.3 pass4sure 000-705 Exam : DB2 Business Intelligence Solutions V8 pass4sure 000-868 Exam : i5 iSeries Technical [...]
[...] Pass4sure 000-705 Testking 000-705 Actualtest 000-705 [...]