Exam 3: Database, Data Warehouse, and Data Mining

An ad-hoc request for specific data or information from a database or warehouse is called a report.

In terms of the major functions performed by a DBMS, data maintenance refers to checking and controlling data integrity over time.

In terms of the major functions performed by a DBMS, "data filtering and profiling" refers to inspecting the data for errors, inconsistencies, redundancies, and incomplete information.

Databases are optimized for extremely fast processing of ____________-or ad hoc user requests for specific data.

The two basic types of database systems are centralized databases and distributed databases.

_____________________ technology archives digital and physical data to meet business needs, as well as regulatory and legal requirements.

In a distributed database configuration, the computers and mobile devices that access data from remote servers are called clients.

______________________ or OLTP systems designed to manage volatile transaction data.

Despite the need for high-quality data, organizational politics and technical issues often make it a difficult goal to achieve.

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

A distributed database allows apps on computers and mobiles to access data from local and _____________ databases.

The primary disadvantage of centralized database configurations is

In terms of the major functions performed by a DBMS, _______________ refers to checking and controlling data integrity over time.

According to your text, ___________ are responsible for increasing the cost of health care by billions of dollars, not to mention, putting lives at risk.

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 an analytical database.

According to your text, the true costs associated with poor data quality are: Cost of repeating analyses + Lost opportunity costs + Cost of unrealized threats

Databases that receive real-time transaction data are called Online Transaction Processing OTLP) systems. Data is then transferred to data warehouses, known as ______________________ for further analysis.

In a distributed database configuration, the computers and mobile devices that access data from remote servers are called ______________.

Despite the need for high-quality data, ________________ and technical issues often make it a difficult goal to achieve.

MDM consolidates data from various data sources into a ___________________, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise. This helps eliminate redundancies, inaccuracies and omissions that might otherwise hinder business processes.