• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

Card Range To Study



Play button


Play button




Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

83 Cards in this Set

  • Front
  • Back
Going from a summary view to progressively lower levels of detail is called data:
An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.
The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.
Big data
A dependent data mart is filled from the enterprise data warehouse and its reconciled data.
Which of the following advances in information systems contributed to the emergence of data warehousing?
Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms.
When multiple systems in an organization are synchronized, the need for data warehousing increases.
Drill-down involves analyzing a given set of data at a finer level of detail.
A fact table holds descriptive data about the business.
The enterprise data model controls the phased evolution of the data warehouse.
Grain and duration have a direct impact on the size of fact tables.
An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.
Rotating the view of a multidimensional database for a particular data point is called data:
An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.
The use of a set of graphical tools that provides users with multidimensional views of their data is called:
on-line analytical processing (OLAP).
The grain of a data warehouse indicates the size and depth of the records.
There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.
Which of the following organizational trends does not encourage the need for data warehousing?
Which of the following data-mining techniques identifies clusters of observations with similar characteristics?
Clustering and signal processing
Informational systems are designed for all of the following EXCEPT:
running a business in real time.
Logical data marts are physically separate databases from the enterprise data warehouse.
An event is a database action that results from a transaction.
Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.
Which of the following is NOT an objective of derived data?
Eliminate the need for application software
All of the following are some beneficial applications for real-time data warehousing EXCEPT:
data entry.
Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.
A corporate information factory (CIF) is a comprehensive view of organizational data in support of all user data requirements.
A logical data mart is a(n):
data mart created by a relational view of a slightly denormalized data warehouse.
Medical claims and pharmaceutical data would be an example of big data.
A dependent data mart:
is filled exclusively from the enterprise data warehouse with reconciled data.
The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.
The development of the relational data model did not contribute to the emergence of data warehousing.
A database action that results from a transaction is called a(n):
An operational data store (ODS) is not designed for use by operational users.
NoSQL is a great technology for storing well-structured data.
Which of the following data-mining techniques searches for patterns and correlations in large data sets?
Rule discovery
Factless fact tables may apply when:
we are deleting correlated data.
Conformed dimensions allow users to do the following:
query across fact tables with consistency.
An operational data store (ODS) is a(n):
integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.
All of the following are limitations of the independent data mart EXCEPT:
it is often more expedient to build a data mart than a data warehouse.
When we consider data in the data warehouse to be time-variant, we mean:
data in the warehouse contain a time dimension so that they may be used to study trends and changes.
Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.
All of the following are unique characteristics of a logical data mart EXCEPT:
the process of creating a logical data mart is lengthy.
A data mart is a(n):
data warehouse that is limited in scope.
The real-time data warehouse is characterized by which of the following?
Data are immediately transformed and loaded into the warehouse.
An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:
A snowflake schema is usually heavily aggregated.
Informational systems are designed to support decision making based on historical point-in-time and prediction data.
Data that are never physically altered once they are added to the store are called ________ data.
The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:
Every key used to join the fact table with a dimension table should be a ________ key.
A class of database technology used to store textual and other unstructured data is called:
The analysis of summarized data to support decision making is called:
informational processing.
Periodic data are data that are never physically altered or deleted once they have been added to the store.
When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.
Operational metadata are derived from the enterprise data model.
Transient data are never changed.
________ is/are a new technology which trade(s) off storage space savings for computing time.
Column databases
A star schema contains both fact and ________ tables.
A conformed dimension is one or more dimension tables associated with only one fact table.
Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
A data mart is a data warehouse that contains data that can be used across the entire organization.
An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.
For performance reasons, it may be necessary to define more than one fact table for a star schema.
The status of data is the representation of the data after an event has occurred.
The representation of data in a graphical format is called data mining.
A separate data warehouse causes more contention for resources in an organization.
When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:
determining the number of possible values for each foreign key in the fact table.
All of the following are ways to handle changing dimensions EXCEPT:
create a snowflake schema.
Which of the following data-mining applications identifies customers for promotional activity?
Target marketing
One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:
the possibility of a new generation of inconsistent data systems, the data marts themselves.
Operational and informational systems are generally separated because of which of the following factors?
A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.
Which of the following factors drive the need for data warehousing?
Businesses need an integrated view of company information.
Which of the following is true of data visualization?
Correlations and clusters in data can be easily identified.
Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.
An expanded version of a star schema in which all of the tables are fully normalized is called a(n):
snowflake schema.
Grain and duration have a direct impact on the size of ________ tables.
OLAP tools that use the database as a traditional relational database are called:
ROLAP tools.
________ technologies are allowing more opportunities for real-time data warehouses.
Scalable technology is critical to a data mart.
Independent data marts do not generally lead to redundant data and efforts.
Rule discovery searches for patterns and correlations in large data sets.