CIS Ch 13 Business Intelligence and Data Warehouses – Flashcards
Unlock all answers in this set
Unlock answersquestion
A data store is used by the data analyst to create the queries that access the database.
answer
False
question
Operational data and decision support data serve the same purpose.
answer
False
question
Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
answer
False
question
Facts can be computed or derived at run time.
answer
True
question
Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.
answer
True
question
It is a relatively easy task to provide a precise list of characteristics of data-mining tools.
answer
False
question
In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.
answer
True
question
Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____. metadata facts information rules
answer
metadata
question
Analyzing decision support data to generate information is part of ____. data warehousing very large database systems business intelligence distributed processing
answer
business intellegence
question
A data mart is part of the "____" section of the business intelligence framework. People Management Processes Governance
answer
Governance
question
____'s main goal is to provide a comprehensive and consistent definition of all data within an organization. DBMS OLAP Data warehousing MDM
answer
MDM
question
The ____ contains business data extracted from the operational database and from external data sources. data store ETL tools data visualization tool data analysis tool
answer
data store
question
____ provide a unified, single point of entry for information distribution. Decision support systems Portals Data warehouses Dashboards
answer
Portals
question
Data is captured from the OLTP system and placed on the ____ on a near-real time basis. decision support system portal data warehouse dashboard
answer
Data warehouses
question
BusinessObjects is a(n) ____ tool. OLAP data visualization data mining data warehouse
answer
OLAP
question
____ systems provided no data extraction/integration process. Third-generation Mobile BI and cloud-based First-generation BI First-generation departmental decision support Traditional mainframe-based online transaction processing
answer
Traditional mainframe-based online transaction processing
question
From the data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____. usability dimensionality transaction processing sparsity
answer
dimensionality
question
A characteristic of decision support data is ____. high query activity high update volumes highly normalized low aggregation level
answer
high query activity
question
In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses. megabytes gigabytes terabytes petabytes
answer
petabyes
question
Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise. volatility time-variation subject-orientation integration
answer
integration
question
____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses. Data networks Data marts Data cubes OLAPs
answer
data warehouse
question
There are 12 rules that define a(n) ____. data warehouse multidimensional cube OLAP tool star schema
answer
data warehouse
question
The BI architecture is composed of data, people, processes, technology, and the management of such components.
answer
True
question
To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.
answer
True
question
The decision support database query optimizer must be enhanced to support non-normalized structures.
answer
True
question
The data warehouse development life cycle differs from classical systems development.
answer
True
question
Data mining is part of the "____" section of the business intelligence framework. People Management Processes Governance
answer
Process
question
____ are in charge of presenting the data to the end user in a variety of ways. Data stores ETL tools Data visualization tools Data analysis tools
answer
Data visualization tools
question
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. OLAP data mining governance networking
answer
governance
question
A characteristic of operational data is ____. summarized data hundreds of gigabytes high normalization historic data
answer
high normalization
