Exam 3: Database, Data Warehouse, and Data Mining

_________________ are small-scale data warehouses that support a single function or department.

According to your text, "dirty data" costs businesses a lot of money. What is "dirty data" and what are the three factors identified in your text that contribute to its cost?

An advantage of Document Management Systems DMS) is that they reduce the time and effort required to ____________ information the business needs to support decision making

Companies in some industries are required by law to retain financial documents for at least seven years. In large companies, being able to locate and retrieve documents from previous years can be extremely challenging, not to mention the logistical challenge associated with warehousing large amounts of paper. Increasingly, companies that face these challenges are turning to _______________.

An) ________________ stores all related files in one physical location.

According to your text, the true costs associated with poor data quality are: ____________ + Cost to prevent errors + Cost to correct errors.

Companies have always faced the challenge of managing physical documents. However, the most significant current challenge involves ___________________.

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

The principle of 90/90 data use suggests that 90% of the capability to capture, process, format, and distribute data in near real time or faster dissipates within 90 seconds of a transaction occurring.

Which of the following was not listed in your text as a benefit experienced by organizations that use a Document Management System DMS)?

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

_______________ 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 are) 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.

___________________ technology is used to archive the growing amount of physical data

Online analytical processing OLAP) systems designed to manage volatile transaction data.

Distributed databases use an) _____________ architecture to process information requests.

The primary benefits of centralized database configuration are better reporting features and better statistical analysis tools.

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

Specialized software used to analyze large data sets to find patterns, correlation, trends, or other meaningful relationships are pattern recognition applications.

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