Exam 3: Database, Data Warehouse, and Data Mining

Aberdeen's 2012) survey of 176 organizations worldwide found that the volume of physical paper) documents is declining by approximately 30% per year thanks to increased use of digitalization and growing concern for the environment.

Unstructured analytic analysis is a process used to analyze an organization's non-structured data that comes from word processing documents, social media, text messages, audio, faxes, memos, call center or claims notes, and so on.

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

The principle of diminishing data values suggests that many global financial services institutions need near real time data for peak performance.

There are three kinds of enterprise data. Which of the following is not one of the types of enterprise data identified in your text?

Which of the following was not listed in your text as a major document management tool?

Data generated by business apps, sensors, and transaction processing systems TPS) are typically stored first in a ______________.

Because of data volatility 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.

In terms of the major functions performed by a DBMS, _______________ refers to integrating, matching, or linking data from disparate sources.

_____________ data serves as a layer between transactional data in a database and analytical data in a data warehouse.

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

The primary disadvantage of centralized database configurations is transmission delay when users are geo-dispersed.

Master data management MDM) is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.

Data warehouses are designed as online analytical processing OLAP) systems, meaning that the data can be queried and analyzed much more efficiently than __________ application databases.

Organizations often store data in applications with the following characteristics: -Designed and optimized to ensure that every transaction gets recorded and stored immediately. -Volatile because data are constantly being updated, added, or edited. -Online transaction processing OLTP) systems because transactions must be recorded and processed as they occur, in real time. These three characteristics best describe which of the following?

Data warehouses are designed as ______________________________ systems, meaning that the data can be queried and analyzed much more efficiently than OLTP application databases.

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

Aberdeen's 2012) survey of 176 organizations worldwide found that the volume of physical paper) documents is increasing by approximately 30% per year.

Companies have always faced the challenge of managing physical documents. However, the most significant current challenge involves the ___________ of documents that must be reviewed to determine if they should be retained or destroyed.

A recent trend in the field of Business Intelligence BI) involves mining very large data sets that come from billions upon billions of recorded transactions, social media interactions and records of individual user online activities. The trend in using these very large data sets is known as ____________.