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
