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

When the same attribute in related data files has different values, this is called data

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

A physical view shows data as it is actually organized and structured on the data storage media.

A(n) ________ organizes data in two-dimensional tables.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

OLAP is unable to manage and handle queries with very large sets of data.

You have been hired by a national furniture leasing company to implement its first business intelligence systems and infrastructure. To prepare for your initial report, describe the types of data in their firm they can use to support business intelligence and the systems that you will implement to support both their power users and casual users, and explain how these systems or tools work together.

Data ________ occurs when the same data is duplicated in multiple files of a database.

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

An attribute is a characteristic or quality used to describe a particular entity.

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Microsoft SQL Server is a(n)

Which of the following is not a method for performing a data quality audit?

A database record is a grouping of characters into a word, a group of words, or a complete number.

Databases record information about general categories of information referred to as entities.

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

In place of application server software to allow a Web server to communicate with a back-end database, you can use

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?