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

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of

Big data does not refer to

Every record in a file should contain at least one key field.

Legacy systems are used to populate and update data warehouses.

The select operation

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

The project operation

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Data mining is a tool for allowing users to

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

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

A schematic of the entire database that describes the relationships in a database is called a(n)

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

DBMS have a data definition capability to specify the structure of the content of the database.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

Which of the following is not a DBMS for midrange computers?

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

Identify and describe three basic operations used to extract useful sets of data from a relational database.