Exam 3: Database, Data Warehouse, and Data Mining

With text analytics, information is extracted out of large quantities of various types of textual information. Which of the following is not one of the steps involved in text analytics described in your text?

Data warehouse management systems DWMS) are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

What is an Active Data Warehouse? Why is it of growing interest to business organizations?

________________________ are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

Distributed databases use a client/server architecture to process information requests.

A majority of data is seldom accessed after a 3 month period. Which of the following principles is based on this observation?

When a customer calls an organization's customer service center, the service representative has access to a complete history of the customer's previous calls as well as a list of the services they have purchased and a customer profitability score. All of this information is up-to-date and is accessed from the company's _________________.

The primary benefits of centralized database configuration are better quality and better security.

Distributed databases use a _____________ architecture to process information requests.

The primary benefits of centralized database configuration are better _____________ and ________________.

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

According to your text, which of the following is not a major data function performed by a DBMS?

An _______________________ is a relatively new OLAP system that is updated in real-time, providing the most current data available for analysis and decision support apps.

"Big Data" is a recent trend in the field of Business Intelligence BI) that 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.

__________________ is the process of analyzing large sets of data to find patterns, correlation, trends, or other meaningful relationships that can be used to increase revenues, decrease costs, or both.

The key advantage of an active data warehouse ADW) is that it is less expensive to install and operate.

In terms of the major functions performed by a DBMS, "data filtering and profiling" refers to which of the following?

The data pathway model illustrates the way in which data moves through an organization.

Databases that receive real-time transaction data are called _____________________ systems.

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