Exam 3: Database, Data Warehouse, and Data Mining

_________________ refers to refers to an organization's ability to get information to the people who need it to make decisions or react appropriately to business events.

Data in databases are said to be volatile because data is constantly being added or updated by new transactions.

Because of _____________, data from databases are transferred to a data warehouse so that they are ready for quick responses to inquiries.

Because of the very large amount of data and the costs associated with BI applications, small and mid-sized companies with limited IT staff and budgets sometimes use a new BI architecture called Pre-defined BI models.

The data life cycle is a model that illustrates the way in which data moves through an organization.

An) _____________________ is a database for transaction processing systems that uses data warehouse concepts to provide clean data. It is used for short-term decisions involving mission-critical applications rather than for the medium- and long-term decisions associated with the regular data warehouse.

There are three kinds of enterprise data: Transactional data, Master data and Analytical data.

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?

MDM consolidates data from various data sources into a master reference file, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise.

According to a study conducted by MIT Sloan Management Review and IBM top-performing organizations use analytics five times more than lower performers.

Because of volatility, data from databases are transferred to a ________________ so that they are ready for quick responses to inquiries.

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.

Data warehouses and data marts are optimized for all of the following except:

Data __________________ integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

Because the high costs of a data warehouse can make them too expensive for a company to operate, some organizations turn to an alternative, called a _____________.

Data warehouses that integrate data from databases across an entire organization are called _________________.

According to a study conducted by MIT Sloan Management Review and IBM, top performing companies use BI and business analytics for both tactical financial insights e.g. forecasting, budgeting and supply chain management) as well as strategic issues like developing competitive advantages.

What are the two basic types of databases?

Specialized software used to analyze large data sets to find patterns, correlation, trends, or other meaningful relationships are called _______________ tools.

A _________________ database stores all related files in one physical location.