CIS Ch 13 Business Intelligence and Data Warehouses Essay

question

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

Get instant access to
all materials

Become a Member