Quiz #6

The person responsible for updating and maintaining website content.

A content editor

A field (or group of fields) that uniquely identifies a given record in a table.

A primary key

Determines which things go together

Affinity grouping

What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken, in effect paralyzing the outcome?

Analysis paralysis

Enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Business critical integrity constraints

Assigns records to one of a predefined set of classes.

Classification

A heterogeneous population of more homogeneous subgroups.

Clustering segments

Who is the person responsible for updating and maintaining website content?

Content editor

logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Data Warehouse

Is the smallest or basic unit of information.

Data element (or data field)

What is the ultimate outcome of a data warehouse?

Data marts

Logical data structures that detail the relationships among data elements by using graphics or pictures.

Data models

A problem associated with dirty data?

Duplicate data

Stands for extraction, transformation, and loading.

ETL

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part. Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.

Granularities

Which of the following is a problem associated with dirty data?

Inaccurate data Misleading data Nonformatted data

Means immediate, up-to-date information.

Real-time information

What is another term for data that is already contained in a database or a spreadsheet?

Structured data

-Numbers and types of operational databases increased as businesses grew. -Many companies had information scattered across multiple systems with different formats. -Completing reporting requests from numerous operational systems took days or weeks

Why were data warehouses created?