1.Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
a.metadata
b.facts
c.information
d.rules
2.Analyzing decision support data to generate information is part of ____.
a.data warehousing
b.very large database systems
c.business intelligence
d.distributed processing
3.Data mining is part of the “____” section of the business intelligence framework.
a.Peopl
b.Management
c.Processes
d.Governance
4.A data mart is part of the “____” section of the business intelligence framework.
a.People
5.____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
a.DBMS
b.OLAP
c.Data warehousing
d.MDM
6.The ____ contains business data extracted from the operational database and from external data sources.
a.data store
b.ETL tools
c.data visualization tool
d.data analysis tool
7.____ are in charge of presenting the data to the end user in a variety of ways.
a.Data stores
c.Data visualization tools
d.Data analysis tools
8.____provide a unified, single point of entry for information distribution.
a.Decision support systems
b.Portals
c.Data warehouses
d.Dashboards
9.Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
a.decision support system
b.portal
c.data warehouse
d.dashboard
10.BusinessObjects is a(n) ____ tool
a.OLAP
b.data visualization
c.data mining
d.data warehouse
11.Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.
b.data mining
c.governance
d.networking
12.____ systems provided no data extraction/integration process.
a.Third-generation Mobile BI and cloud-based
b.First-generation BI
c.First-generation departmental decision support
d.Traditional mainframe-based online transaction processing
13.From the data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.
a.usability
b.dimensionality
c.transaction processing
d.sparsity
14.A characteristic of decision support data is ____.
a.high query activity
b.high update volumes
c.highly normalized
d.low aggregation level
15.A characteristic of operational data is ____.
a.summarized data
b.hundreds of gigabytes
c.high normalization
d.historic data
16.In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data warehouses.
a.megabytes
b.gigabytes
c.terabytes
d.petabytes
17.Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
a.volatility
b.time-variation
c.subject-orientation
d.integration
18.____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
a.Data networks
b.Data marts
c.Data cubes
d.OLAPs
19.There are 12 rules that define a(n) ____.
a.data warehouse
b.multidimensional cube
c.OLAP tool
d.star schema
20.The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
a.keys
b.relationships
c.cubes
d.dimensions
21.Computed or derived facts are sometimes called ____to differentiate them from stored facts.
a.details
b.attributes
c.metrics
d.fact tables
22.In a star schema, dimensions are normally stored in ____.
a.attributes
b.indexes
c.fact tables
d.dimension tables
23.In a star schema, attributes are often used to search, filter, or classify ____.
a.tables
b.stars
c.fact
24.The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.
a.time
b.cube
c.third
d.multi
25.The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____and drilldown/roll up data analysis
a.hierarchy
b.de-normalization
c.normalization
d.aggregation
26.Fact and dimension tables are related by ____ keys.
a.shared
b.primary
c.foreign
d.linked
27.In a typical star schema, each dimension record is related to thousands of ____ records.
a.attribute
b.fact
c.key
d.star
28.A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
a.snowflake
b.starflake
c.mesh
d.matrix
29.____splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time
a.Normalization
b.Meta modeling
c.Replication
d.Partitioning
30.In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
a.GUI
b.operational database
c.multidimensional database
d.data cube
31.The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
a.normalization
b.denormalization
c.star schema
d.multidimensional schema
32.Decision support data tend to be non-normalized, ____, and pre-aggregated.
a.unique
b.duplicated
c.relational
d.sorted
33.The ____ schema is designed to optimize data query operations rather than data update operations.
a.relational
b.circle
c.star
34.ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
a.SQL
c.DDS
d.BI
35.A ____ index is based on 0 and 1 bits to represent a given condition.
a.logical
b.multidimensional
d.bitmapped
36.Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a____.
a.multi cube
b.data matrix
c.data cube
d.hyper cube
37.A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
a.table
b.matrix
c.network
d.cube
38.What is one of the main characteristics of OLAP systems?
a.They use single-dimensional data analysis techniques.
b.They provide complex command-line end-user interfaces.
c.They provide minimal database support.
d.They support client/server architecture.
39.What is a characteristic of ROLAP?
a.It uses the star schema
b.It does not require high resources.
c.It is limited to predefined dimensions.
d.It has low flexibility.
40.A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
b.materialized view