Exam 1

In a ____ operation, a dimension is replaced with a subset of values of the dimension.

dice

Which of the following is a problem with using a single database for both operational and business intelligence processing?

difficulty in summarizing activity across business units

A(n) ____ describes the structure of a data warehouse and contains descriptive data required to access operational database and external data sources.

enterprise data model

Which of the following is not a vendor specified as supporting or using Microsoft Multidimensional Expressions (MDX)?

Novell

Which of the following is not considered one of the checks and balances of Data Governance?

evaluate the application of archival vendors

In a star schema, most of the actual data rows are found in the ____.

fact table

An analytic function computes a single value for a group of rows.

false

The detailed specification for a medical data warehouse is known as ____.

OMOP

The data warehouse model that promotes economies of scale for medical research is known as ____.

SAFTINet

Which of the following is not a standard part of a Multidimensional Expressions (MDX) statement?

SLICE

A hierarchy of multiple data warehouses that are integrated and function as a single data warehouse accessed via a query portal is known as a(n) ____ data warehouse.

federated

The learning curve for production and the learning curve for data transformation costs are both characterized by ____.

high initial costs/effort then a steep decline in costs/effort then a leveling off

Upper level management relies primarily on which of the following data sources to assist in strategic decision making?

integrated data from external data sources and summarized, tactical databases

Which of the following is not an example of a transaction?

internet search

Which of these is not a feature of existing DBMS's that results in a lack of support for summary data retrieval and analytical calculations?

limitations of the TIME clause for analyzing historical trends

A data warehouse requires integration meaning consistent naming conventions, common data formats, comparable measurement scales, and ____ entities across data sources.

matching and merging

A useful business intelligence tool that leverages low refresh costs with more stable fact tables than are found in an operational database is a(n) ____.

materialized view

Data descriptors that define the source, use, value, and meaning of data are known as:

metadata

An ETL solution may be preferred instead of an ELT solution when:

more complex transformations of the data are required

Lower level management relies primarily on which of the following data sources to assist in routine decision making?

operational databases

Dependencies based on only a part of a composite primary key are called ____ dependencies.

partial

Regarding Trend Analysis, typical examples of window comparisons do not include which of the following? (choose one)

performance of an advertising group over the next six months

Which of the following is the standard tool for end user analysis of data cubes?

pivot tables

In order to determine the contribution of a company's divisions, a common business intelligence tool for comparisons is ____.

ratio comparison

Which of the following is not an example of a typical lower level management decision?

reallocate resources across divisions

Before it can be loaded into the data warehouse, Neena noticed that the last two years' average monthly sales per person seem to average about $12,000 per employee with a few as low as $1,500 and some as high as $80,000 per month. One employee has been averaging $220,000 per month so Neena is making phone calls to that office and the regional sales office as well. Neena is conducting a(n) ____ check.

reasonableness

Which of the following has not been an advantage gained by organizations that have successfully implemented a data warehouse?

reduced attack surface for external hackers

Which of the following is not a typical intangible benefit of adopting a data warehouse?

reduced risk of data contamination at input

Data refresh from the operational database(s) to the data warehouse has costs and benefits. The net refresh benefit is the value of data timeliness minus the cost of ____.

refresh

Which of these is not an inconsistency of operational databases that hamper usage in Business Intelligence (BI)?

regulatory table attributes

Which of the following has not been a key application driving the adoption of data warehouse projects in the insurance industry?

retail office placement

An example of a ____ operation would be a decision maker shifting their sales data focus from the daily to the quarterly level.

roll-up

Analyzing a "window" is essentially the analysis of a set of ____.

rows

Integration level refers to all of the following data quality indicators except ____.

semantics

In a ____ operation, one or more dimensions are set to specific values and the remaining data cube is displayed

slice

The Learning Curve of skill attainment and the business value of a data warehouse are both characterized by ___.

slow start then rapid improvement then leveling off

Data warehouses essentially consist of a long series of ____ , each of which represents operational data captured at a point in time.

snapshots

Which of these is a disadvantage of providing data using a multidimensional cube instead of in relational tables?

storage space

Which of the following would not be an additive measure?

street numbers

Examples of ____ include a university that does not uniformly have departments in all of its constituent colleges or products that do not neatly fit in a category under analysis.

summarizability problems

Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to go in the normalization process.

three

The subject-orientation of a data warehouse is organized around all of these major business subjects or entities except ____.

time periods

A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.

transitive dependency

Analytic functions and aggregate functions operate on groups of rows.

true

Which of the following is not a cost or risk associated with data warehouse development and usage?

typical first year labor investment of 10,000 hours

An ELT solution may be preferred instead of an ETL solution when:

using the same vendor for the source and target

Which of the following is not one of the three V's of Big Data?

value

In a star schema, a ____ relationship connects from each of the outer tables to the central table(s).

1-to-M

Which of the following is the maximum number of dimensions supported by Multidimensional Expressions (MDX)?

128

Before converting a table into 3NF, it is imperative the table already be in ____.

2NF

Individual-level data provides fast response to a wide range of business intelligence needs while summarized data provides fast response to unique queries.

False

Knowledge Management emphasizes a long-term, organization-wide perspective on data quality to ensure support for management decision making.

False

Normalization is a very important database design ingredient and the highest level is always the most desirable.

False

The current relational database schema pattern that now dominates in data warehouses is known as a constellation schema.

False

The database operator (DBO) is a support role with responsibilities related to individual databases and Database Management Systems (DBMS)'s.

False

To move from 2NF to 3NF, repeating groups must be eliminated by making sure that each column has only single valued entries.

False

In a ____ operation, users navigate from a more general level to a more specific level.

drill-down

In regular expressions, the usual metacharacter used to remove the special meaning of another metacharacter is:

\

Operational or production databases used in transaction processing assist primarily with decisions that involve detailed data about ____.

business processes

An attribute that determines the value of another attribute is a ____.

candidate key

An atomic attribute ____.

cannot be further subdivided

According to William Inmon's 1990 definition, a data warehouse refers to a logically centralized data repository where data from operational databases and other sources are integrated, standardized, and ____ to support business intelligence.

cleaned

Which of the following is not an example of "dirty data?"

data column with data type "integer" that contains the whole numbers 0 - 99,999

Which of the following is not a feature of Multidimensional Expressions (MDX)?

data dimension cascades

Data redundancy produces ____.

data integrity problems

Alex is Executive Vice-President for the Sales Division and has lost patience waiting for an enterprise data warehouse to be deployed. A bottom-up approach to begin a business intelligence initiative in the organization could begin with a(n) ____ deployment that only handles sales related data.

data mart

Kendra is a business analyst in an organization with an enterprise data warehouse. Which of the following servers is most likely the one her desktop computer connects to and then displays key metrics via a business intelligence dashboard?

data mart

While browsing the web, you notice that advertisements highly relevant to your interests keep appearing on the edges of your webpages. Which of these business intelligence tools is most likely responsible?

data mining

Which of the following tools is most helpful in identifying data quality problems?

data profiling

Which of the following is not one of the three pillars of Knowledge Management?

data quality

A business analyst is examining sales trends in an operational database. Which of the following problems was most likely not caused by this analysis?

delayed shipping of products to customers

A comparison of earlier data with more recent data yields new rows, changed rows, and deleted rows collectively known as a(n) ____. (Type in your response.)

delta

In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies.

dependency

Which of the following is an example of systems integration?

Allowing updates entered in the sales tracking terminals to be recorded in the online accounting ledger.

Given this table, which of the four columns does not illustrate a dimension? Column AColumn BColumn CColumn DPRODUCTLOCATIONMANUFACTURERSALESMono LaserCaliforniaCanon80Mono LaserUtahCanon40Ink JetCaliforniaHP110Ink JetUtahHP90

D

Which of these is not an example of a dimension hierarchy?

Equipment: printer, copier, fax machine

Which of the following technologies is helpful in making web pages useful for business intelligence?

Extensible Markup Language (XML)

A data cube is limited to three "sides" such as in the the textbook's Figure 13.1 which has "sides" Location, Product, and Time.

False

The data warehouse storage architecture that was developed to combine two existing data warehouse storage architectures is ____.

HOLAP

The data warehouse storage architecture with the highest query performance is ____.

MOLAP

The data warehouse storage architecture with the lowest storage capacity is ____.

MOLAP

The data warehouse storage architecture that makes the most use of materialized views is ____.

ROLAP

The basic template for business intelligence requirements in a retail data warehouse deployment is known as ____.

TPC-DS

A dependency of one nonprime (non-key) attribute on another nonprime (non-key) attribute is a transitive dependency.

True

A determinant is any attribute whose value determines other values within a row.

True

A table is in 2NF if it is in 1NF and it includes no partial dependencies.

True

An advantage of using a time series is that many statistical functions can operate directly on time-series data.

True

Because of the different processing requirements, data warehouse designs use different data representations than operational databases.

True

Data warehouses typically have some violations from Boyce-Codd Normal Form to reduce effort to join large tables.

True

Each level of management decision making and business operations has its own information life cycle.

True

In a star schema, the fact table(s) are in the center and the dimension tables are connected only to the fact table(s).

True

In order to tune the data for analytical purposes, you may have to denormalize portions of the database design.

True

Normalization works through a series of stages called normal forms.

True

One of the most important responsibilities of the data administrator is the development of an enterprise data model (EDM).

True

Sparsity in a data cube indicates the extent of empty cells.

True

The data administrator (DA) is a middle- or upper-management position with broad responsibilities for information resource management.

True

Transaction processing relies on operational databases with current data at the individual level, while business intelligence processing utilizes data warehouses with historical data at both the individual and summarized levels.

True

Which of the following is the largest data unit?

Yottabyte