Test bank ch 6 business driven information systems PDF

Preview

Summary

Download Test bank ch 6 business driven information systems PDF

Description

1.

A collection of related data elements. INCORRECT No answer given THE ANSWER Record (= row)

2.

Reveals the relationship between variables along with the nature and frequency of the relationships. INCORRECT No answer given THE ANSWER Associated detection

3.

The common term for the representation of multidimensional information. INCORRECT No answer given THE ANSWER Cube

4.

Contains a subset of data warehouse information. INCORRECT No answer given THE ANSWER Data mart

5.

The process of analyzing data to extract information not offered by the raw data alone. INCORRECT No answer given THE ANSWER Data mining

5 Matching questions 1.

2.

Relational integrity constraints INCORRECT No answer given THE ANSWER E. Rules that enforce basic and fundamental information-based constraints. e.g. not allowing someone to order zero pounds of raw materials from a supplier Extraction, transformation, and loading (ETL) INCORRECT No answer given THE ANSWER A. A process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.

3.

Advantages of relational databases INCORRECT No answer given THE ANSWER D. Increased flexibility, increased scalability and performance, reduced data redundancy, increased information integrity, increased information security

4.

Transactional information INCORRECT No answer given THE ANSWER C. All of the information contained within a single business process or unit of work. Its primary purpose is to support daily operational tasks. e.g. airline ticket, sales receipt, packing slip

5.

Information cleansing/scrubbing INCORRECT No answer given THE ANSWER B. A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information. Specialized software tools exist that use sophisticated procedures to analyze standardize, correct, match, and consolidate data warehouse information.

A. A process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. B. A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information. Specialized software tools exist that use sophisticated procedures to analyze standardize, correct, match, and consolidate data warehouse information. C. All of the information contained within a single business process or unit of work. Its primary purpose is to support daily operational tasks. e.g. airline ticket, sales receipt, packing slip D. Increased flexibility, increased scalability and performance, reduced data redundancy, increased information integrity, increased information security E.

Rules that enforce basic and fundamental information-based constraints. e.g. not allowing someone to order zero pounds of raw materials from a supplier

5 Multiple choice questions 1.

Occurs when the same data element has different values.

1.

Data inconsistency

2.

Data dictionary

3.

Integrity constraints

4.

Data quality audits Document, presentation, spreadsheet, database

1.

Information integrity

2.

Information formats

3.

Information granualities

2.

4. 3.

1.

Statistical analysis

2.

Relational integrity constraints

3.

Information granularity

4.

4.

Information levels Stores information is the form of logically related two dimensional tables.

Relational database model Deals with the physical storage of information on a storage device.

1.

Relational database model

2.

Data quality audits

3.

Physical view of information

4. 5.

Logical view of information Logical data structures that detail the relationships among data elements using graphics or pictures.

1.

Metadata

2.

Data models

3.

Data mart

4.

Data warehouse

5 True/False questions Analyzes unstructured data to find trends and patterns in words and sentences. → Text mining

1.

INCORRECT No answer given THE ANSWER True

2.

Provides details about data. e.g. metadata for an image could include its size, resolution, and date created. → Database INCORRECT No answer given THE ANSWER False It should be → Metadata

3.

Analyzing items as websites and checkout scanner information to detect customers' buying behavior and predict future behavior by identifying affinities among customers' choices of products and services. → Market basket analysis

INCORRECT No answer given THE ANSWER True

4.

Occur when a system produces incorrect, inconsistent, or duplicate data. → Data dictionary INCORRECT No answer given THE ANSWER False It should be → Data integrity issues

5.

Determine the accuracy and completeness of a company's data. → Data dictionary INCORRECT No answer given THE ANSWER False It should be → Data quality audits...