ITM Chapter 6 Flashcards

_______ 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

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

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

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

_______ 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

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

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

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

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

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

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

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

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

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

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

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

T/F All Data systems have the same format?

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

T/F Metadata is data about data?

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

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

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

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

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

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

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

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

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

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

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

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 physical view of information focuses on how individual users logically access information to meet their own particular business needs
T/F

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

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

Explain the difference between transactional and analytical information.

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

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.

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

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

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

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

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

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

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

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

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

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.

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

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

What are the four aspects of data?

What are the two types of data?

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.

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

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

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

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

What are some data-driven website advantages?

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

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

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

________ 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

What is data mining?

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

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