_______ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.
a. data warehouse
b. data mart
c. data driven website
d. web blog

C

The process of analyzing data to extract information not offered by the raw data alone.
a. information scrubbing
b. ETL
c. data governance
d. data mining

D

_______ provides details about data
a. data dictionary
b. data element
c. metadata
d. foreign key

C

_______ stores information about a person, place, thing, transaction, or event.
a. metadata
b. attribute
c. data element
d. entity

D

_______ helps users graphically design the answer to a question against a database.
a. query by example tool
b. structured query language
c. relational database model
d. relational database management system

A

An example of transactional information would be:
a. product statistics
b. sales projections
c. future growth projections
d. sales receipt

D

The smallest or basic unit of information is referred to as:
a. database model
b. metadata
c. data element
d. database

C

Fixing or discarding inconsistent or incorrect data is known as:
a. data mining
b. data organizing
c. data cleaning
d. data exploring

C

Revealing the relationship between variables with nature and frequency of relationship is known as:
a. statistical analysis
b. cluster analysis
c. association detection
d. data cleaning

C

T/F A representation of multidimensional information can be referred to as a "cube".

True

Multiple Choice:
Which of the following are both examples of analytical information that might be stored in a database?
A. Sales receipts and packing slips
B. Sales receipts and future growth
C. Trends and packing slips
D. Product statistics and sales projections

D

Multiple Choice:
Which of the following is NOT one of the five common characteristics of high quality information?
A. Concise
B. Timely
C. Complete
D. Accurate

A

Short Answer:
Give at least one advantage of a data driven website.

Answer: (1) The content is easy to manage. (2) It is easy to store large amounts of data. (3) It is easy to eliminate human errors.

True/False:
Time-series information is used in association detection.

False

Multiple Choice:
Which of the following is NOT a way by which data warehouses increase effectiveness?
A. Analyzing trends
B. Identifying product waste
C. Understanding competitors
D. Developing customer profiles

B

T/F Data mining is one of the four aspects of Data we need to consider?

False

T/F All Data systems have the same format?

False

Can Databases be linked together and if so what is it called?

They can be linked together, even multiple databases at a time and this is called a relational database.

T/F Metadata is data about data?

True

Companies use ______________ techniques to analyze particular data in order to compile a complete picture of their operations allowing identification of trends and improved forecasts.
A. Data mining
B. Unstructured Data
C. Market Basket
D. Business Intelligence

A

The primary purpose of a data warehouse is to combine information.
True
False

True

If a grocery store is trying to analyze data regarding what percentage of the time customers buying bread are also buying peanut butter they would use the data mining technique known as:
a. Cluster Analysis
b. Statistical Analysis
c. Time-series Analysis
d. Market Basket Analysis

D

It is crucial for businesses to understand digest, analyze and filter high-quality information in order to see growth and success in their industry. Information that has a primary purpose to support daily operational tasks is known as _______________.
a. Analytical Information
b. Transactional Information
c. Metadata
d. Information granularity

B

There are common characteristics of high-quality information to make certain that systems do not suffer from data integrity issues. Which of these characteristics is not one of them?
a. Accurate
b. Complete
c. Replicable
d. Unique

C

True/False. Information cleansing or scrubbing is a process that weeds out and fixes or discards incorrect or incomplete information.

True

True/False. Web mining analyzes unstructured data to find trends and patterns in words and sentences.

False

What is a technique used to divide information sets into manually exclusive groups so that members of each group are close together and different groups are far away?
a) Association Detection
b) Cluster Analysis
c) Market Basket Analysis
d) Statistical Analysis

B

Text mining:
a) assigns records to one of a predefined set of classes
b) determines which things go together
c) segments a heterogeneous population of records into a number of more homogeneous subgroups
d) analyzes unstructured data to find trends and patterns in words and senternces

D

The data warehouse enables business users typically managers, to be more effective in all these ways EXCEPT:
a) grouping similar products together
b) developing customer profiles
c) identifying financial issues
d) understanding competitors

A

Data governance refers to the overall management of the availability usability, integrity, and security of company data.

True

A data dictionary:
a. compiles all of the metadata about the element in the data model
b. stores information in the form of logically related two-dimensional tables
c. allows users to create read, update, and delete data in a relational database
d. none of the above

A

A physical view of information focuses on how individual users logically access information to meet their own particular business needs
T/F

False

Another word for information cleansing is:
a. wiping
b. destroying
c. scrubbing
d. washing

C

The three common forms for mining structured and unstructured data are:
a. cluster analysis statistical analysis, and multidimensional analysis
b. data analysis, cluster analysis, and configuration analysis
c. cluster analysis, association detection, and statistical analysis
d. cluster analysis, alignment analysis, and statistical analysis

C

Explain the difference between transactional and analytical information.

Transactional information encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. Analytical information encompasses all organizational information, and its purpose is to support the performing of managerial analysis tasks. Analytical information is useful when making important decisions such as whether a company should build a new plant of hire more sales personnel.

What is a major pitfall of real-time information?
a. It is constantly changing.
b. It is often inaccurate.
c. It is often incomplete.
d. All of the above

A

Which of the following is NOT a serious consequence that businesses face when using low-quality information?
a. Difficulty tracking revenue because of inaccurate invoices.
b. Inability to build strong relationships with customers.
c. Difficulty identifying the business's most valuable customers
d. Lost revenue opportunities from marketing to valuable customers.

D

Name two defined policies that a company that supports a data governance program specifies.

2 of these:
-who is accountable for various aspects of the data
-the process concerning how to store, archive, back up, and secure the data
-procedures identifying accessibility levels for employees

Columns and fields such as the primary key and foreign key are examples of what?
a. Entities
b. Attributes
c. Metadata
d. Data models

B

T/F The four aspects of data are data type data timelines, data quality, and data governance

True

A _____ key is one or more columns that can be used to identify a unique row in a table?

Primary

_____ keys are keys from a different table than the one in which they reside?

Foreign

T/F Market basket analysis is the items people tend to buy separate

False

T/F A statistical analysis requires high quality data a sturdy DBMS, and a solid statistical skills

True

The four primary traits that help determine the value of information include:
a. Information type: transactional and analytical
b. Information timeliness
c. Information quality
d. Information governance
e. All of the above

E

Of the five common characteristics of high quality information which of the following has to do with each transaction and event only being represented once in the information?
a.Complete
b. Consistent
c. Unique
d. Timely
e. Accurate

C

Which of the following is not true?
a. Metadata provides details about data.
b. A data element is the largest or most broadest unit of information.
c. Data models are logical data structures that detail the relationships among data elements using graphics or pictures.
d. A data dictionary is a compilation of all the metadata about the data elements in the data model.

B

List some examples of serious business consequences that can occur due to using low quality information to make decisions.

-Inability to accurately track customers.
-Difficulty identifying the organization's most valuable customers
-Inability to identify selling opportunities
-Lost revenue opportunities from marketing to nonexistent customers
-The cost of sending undeliverable mail
-Difficulty tracking revenue because of inaccurate invoices
-Inability to build strong relationships with customers

Which of the common forms for mining structures and unstructured data is a technique used to divide information sets into mutually exclusive groups where members of each group are closely grouped together while the different groups are as far apart as possible?
a. Association detection
b. Statistical Analysis
c. Cluster Analysis
d. Separation Analysis

C

What are the four aspects of data?

Type, timeliness, quality, and governance

What are the two types of data?

Transactional and analytical

Which of the following is NOT a characteristic of Data quality?
A. Accurate
B. Timely
C. Unique
D. Consistent
E. All are characteristics of Data quality.

E

A field that or group of fields that uniquely identifies a given record in a table is __________.
A. Foreign Key
B. Primary Key
C. Entity
D. Record

B

Which of the following is the most inclusive?
A. Data mart
B. Data field
C. Data record
D. Data warehouse

A

What are five common characteristics of high-quality information? Name two or three

Accurate, complete, consistent, timely, unique

What is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two?
a. primary key
b. foreign key
c. record
d. report

B

What are some data-driven website advantages?

- Easy to manage content
- Easy to store large amounts of data
- Easy to eliminate human errors

What is the primary purpose of a data warehouse?
a. combine information
b. store information
c. analyze trends

A

Association detection reveals the relationship between variables along with the nature and frequency of the relationships.

True

Data governance refers to the overall management of the availablility usability, integrity, and security of company data.

True

________ is a process that weeds out and fixes or discards inconsistent incorrect, or incomplete information.
A. Extraction
B. Data redundancy
C. Information cleansing or scrubbing
D. Data quality audits

C

What is data mining?

The process of analyzing data to extract information not offered by the raw data alone.

_______ are predictions based on time-series information.
A. Association detection
B. Market basket analysis
C. Forecasts
D. Association detection

C

Cluster analysis is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.
A. True
B. False

A