FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database, Data Warehouse, and Data Mining

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

_________________ 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.

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

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

What are the two basic types of databases?

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

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

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.

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 _________________.

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

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

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.

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.

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

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.