Exam 6: Foundations of Business Intelligence: Databases and Information Management

________ tools are used to analyze large unstructured data sets,such as e-mail,memos,and survey responses to discover patterns and relationships.

A field identified in a record as holding the unique identifier for that record is called the:

What are the similarities and differences between a data warehouse and a data mart?

Associations are occurrences linked to multiple events.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

You have been asked to design a new contracts database for a small publishing company.What fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

OLAP enables:

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

Which of the following enables a DBMS to reduce data redundancy and inconsistency?

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

The project operation:

DBMSs typically include report generating tools in order to:

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.

List three ways that a business's data can become redundant or inconsistent.

A ________ is an example of pre-digital data storage that is comparable to a database.

In a large organization,which of the following functions would be responsible for physical database design and maintenance?

A characteristic or quality that describes a particular database entity is called a(n):

An organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n):