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

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

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.

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

Common Gateway Interface is a specification for processing data on a Web server.

In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time, except when the data are stored in very large databases.

In a relational database, the three basic operations used to develop useful sets of data are

An alternative to using application server software for interfacing between a Web server and back-end databases is

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

In a table for customers, the information about a single customer would reside in a single

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.

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data?

Each characteristic or quality describing a particular entity is called an attribute.

Which of the following best illustrates the relationship between entities and attributes?

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

Which of the following is not one of the main problems with a traditional file environment?

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

OLAP is used for multidimensional data analysis.

The select operation