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
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 Correct:C
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 Correct:D
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) Correct:A
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
Correct:C
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
Correct:D
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 Correct:D
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 Correct:D
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 bidirectional update of operational data
D.Allows data load rules to be shared across multiple tools
Correct:D
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 Correct:B
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 Correct:C
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 email C.Invite collaborative input of remote users incorporating Domino D.Implement a webbased reporting tool with drill down capabilities Correct:D
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
Correct:A
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
Correct:A
14.A client has an application that was written inhouse. 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 Correct:A
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
Correct:D
16.Given a Business Intelligence solution that measures near realtime 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.ondemand notification
C.frequent text report generation
D.triggers that immediately update warehouse tables
Correct:A
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 webbased service to deliver additional summarized reports
C.Hire business specialist consultants to produce industry standard reports
D.Implement a frontend tool which allows users to create their own summarized reports
Correct:D
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
Correct:D
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
Correct:B
20.In a large warehouse environment, what method or mechanism is often used to minimize the effect of online disk failure?
A.Striping B.Blocking C.Mirroring D.Double buffering Correct:C
21.A company has limited programming expertise and would like a tool that provides automated data extraction with a GUI. What should they choose?
A.Warehouse Manager B.Relational Connect C.Information Catalog
D.WebSphere Application Development
Correct:B
22.At what point in the data warehouse implementation process should data sources be identified?
A.After schema design
B.After data cleansing
C.After user needs are defined
D.After selection of an extraction tool
Correct:C
23.When designing a Business Intelligence solution, how should the Information Technology organization be primarily involved?
A.provide capacity requirements
B.define the business critical success factors
C.provide business rules to be used in the warehouse
D.provide the skills and knowledge to build a Business Intelligence solution
Correct:D
24.A major telecommunications provider wishes to identify which of its current customers may soon switch to an alternative provider. How can they support a marketing program designed to retain those customers deemed most likely to move their business to the competition?
A.Perform demographic analysis for customers for each geographic region
B.Build a mining base clustering active customers by their buying patterns
C.Build a multidimensional profile of the competition’s customers and their offerings
D.Create a set of multidimensional profiles that summarize the characteristics of prior customers that have switched
Correct:D
25.A rapidly growing webbased brokerage wants to implement a data warehouse to provide analysis capability for several hundred traders. What is the most important factor that needs to be considered in making a hardware decision for the server?
A.Number of users
B.Source data hardware platform
C.Trader’s client hardware platform D.Geographical dispersion of desktop systems Correct:A
26.What calculation method is NOT implemented in a DB2 OLAP Server installation?
A.Unary B.Formula C.Calc Script D.Binary Anding Correct:D
27.While viewing monthly sales by region, an executive needs to understand which stores have increased total sales over last month. In addition to measures, what dimensions should be viewed? A.Stores and time
B.Region and sales
C.Stores and region D.Stores, sales and product Correct:A
28.A primary concern of store managers and executive staff is the reduction of product loss due
to damage and theft, also known as shrinkage. To better understand shrinkage, management wants to see how much product and which products are lost every week. What is required to address this concern?
A.Allow more frequent stock turns
B.Perform more frequent inventory checks
C.Monitor overall revenue associated with theft and damage D.Track current inventory, product sales and inventory received Correct:D
29.Which of the following Business Intelligence terms is used to describe the expansion of an analytical report to show a finer level of detail along one dimension?
A.Pivot B.Roll up C.Drill down
D.Compression
Correct:C
30.Which of the following factors is LEAST likely to affect sizing considerations when configuring
a server for a Business Intelligence implementation?
A.The number of users
B.The data propagation requirements
C.The amount of historical data being stored
D.Intention to use materialize query tables for better performance
Correct:B
Testking ibm 000-705 Interactive Testing Engine Included!
112 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Free down:Testking ibm 000-705
Free down:Pass4sure ibm 000-705
If you would like to make a comment, please fill out the form below.
[...] 000-443 Exam : DB2 Content Manager V8.3 Testking 000-705 Exam : DB2 Business Intelligence Solutions V8 Testking 000-868 Exam : i5 iSeries Technical [...]
[...] testking 000-705 [...]
[...] 000-705 testking 000-705 transcender 000-705 actualtest 000-705 Pass4sure Share and [...]