IS 290 Exam 2 (BP10, Ch8, Ch7, BP7, Ch6) – Flashcards
Unlock all answers in this set
Unlock answersquestion
What are forecasts?
answer
Predictions made on the basis of time-series information
question
What is analysis latency?
answer
The time from which data re made available to the time when analysis is complete
question
What is a technique used to divide an information set 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?
answer
Cluster analysis
question
What is data latency?
answer
The time duration to make data ready for analysis and loading the data into the database
question
What is decision Latency?
answer
the time it takes a human to comprehend the analytic result and determine an appropriate action
question
What is time-series information?
answer
Time stamped information collected at a particular frequency
question
What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?
answer
Association Detection
question
Which company uses statistical analysis to automatically detect potential issues, provide quick and easy access to reports, and perform multidimensional analysis on all warranty information?
answer
Whirlpool
question
Which form of BI has managers and analysts as its primary users?
answer
Operational BI
question
Which form of BI uses the time frame of days to weeks to months?
answer
Tactical BI
question
Which form of BI uses real-time metrics for its data?
answer
Operational BI
question
Which form of BI uses months to years as its time frame?
answer
Strategic BI
question
Which of the following represents market basket analysis?
answer
All of these
question
Which of the following is a form of statistical analysis?
answer
Forcasting
question
Which of the following is a business benefit of BI?
answer
Up-to-the minute information for everyone
question
Which of the following is one of the four main categories of BI benefits?
answer
Quantifiable benefits
question
Which type of BI achieves long-term organizational goals?
answer
Strategic BI
question
Which type of BI benefits includes working time saved in producing reports and selling information to suppliers?
answer
Quantifiable benefits
question
Which type of BI benefits are the results of discoveries made by creative users?
answer
Unpredictable benefits
question
Which type of BI benefits includes improved communication throughout the enterprise, improved job satisfaction of empowered users, and improved knowledge sharing?
answer
Intangible benifts
question
Which type of BI conducts short-term analysis to achieve strategic goals?
answer
Tractical BI
question
Which type of BI manages daily operations and integrates BI with operational systems?
answer
Operational BI
question
Achieving perfect information is almost impossible. The more complete and accurate an organization wants its information to be, the more it costs. Which two variables are used to determine the trade-off for perfect information?
answer
Accuracy vs completeness
question
A data warehouse is a _________ collection of information - gathered from many different ___________ databases - that supports business-analysis activities and decision-making tasks.
answer
logical, operational
question
A dimension is a particular attribute of information. Each layer in a data warehouse or data mart represents information according to an additional dimension. What is the common term for the representation of multidimensional information?
answer
Cube
question
All of the following are reasons why operational systems are not appropriate for business analysis except:
answer
Operational systems are integrated
question
A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart?
answer
Information is multidimensional, meaning it contains layers of columns and rows.
question
Lands' End created an organization-wide data warehouse so all its employees could access organizational information. Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse, because it was simply too big, too complicated, and had too much irrelevant information. Lands' End knew there was valuable information in its data warehouse, and it had to find a way for its employees to easily access the information. What was Lands' End's solution?
answer
Build a data mart
question
What do data warehouses support?
answer
OLAP and analytical processing
question
What does the Data Warehousing Institute estimate that low-quality information costs U.S. businesses annually?
answer
$600 billion
question
What is a dimension?
answer
A particular attribute of information
question
What is data mining?
answer
Process of analyzing data to extract information not offered by the raw data alone
question
What is information that people use to support their decision making efforts?
answer
Business intelligence
question
What is the primary purpose of a data warehouse?
answer
To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
question
What is the primary problem most organizations face today concerning information?
answer
Data rich, information poor
question
What types of BI decisions include predicting sales, determining correct inventory levels, and distribution schedules among outlets, and loss prevention?
answer
Retail and sales BI decisions
question
What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use, credit card spending by new customers, and which kinds of customers will best respond to new loan offers?
answer
Banking BI decisions
question
What types of BI decisions include forecasting claim amounts and medical coverage costs, classifying the most important elements that affect medical coverage; predicting which customers will buy new insurance policies?
answer
Insurance BI decisions
question
When does information cleansing occur in the data warehouse?
answer
During the ETL process and once it is in the data warehouse
question
Which of the following describes ETL?
answer
All of these
question
Which of the following statements is true regarding customer information?
answer
All of these
question
Which of the following occurs during data cleansing?
answer
All of these
question
Which of the following statements is true?
answer
The more complete and accurate an organization wants to get its information, the more it costs
question
Which of the following does not draw a parallel between the challenges in business and the challenges of war?
answer
Accurate and complete information
question
Which of the following is not one of the parallels between challenges in business and those of war?
answer
Using tactical business intelligence
question
Which of the following can use BI to make informed decisions?
answer
all of these
question
Why is Ben & Jerry's using business intelligence?
answer
to improve quality
question
Why is Noodles & Company using business intelligence?
answer
to improve financial analysis
question
Why would a business use a data warehouse that offers strategic level, external, integrated, and historical information?
answer
all of these
question
All of the following are advantages of database-stored information except:
answer
Increased information redundancy
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
In the relational database model, what is a characteristic or property of an entity?
answer
Attribute
question
What are characteristics or properties of an entity called?
answer
All of these
question
What are the rules that help ensure the quality of information?
answer
integrity constraints
question
What are the rules that enforce basic and fundamental information-based constraints?
answer
Relational integrity constraints
question
What is a backward integration?
answer
Takes information entered into a given system and sends it automatically to all upstream systems and processes.
question
What is a foreign key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
question
What is a forward integration?
answer
Takes information entered into a given system and sends it automatically to all downstream systems and processes.
question
What is an integration?
answer
Allow separate systems to communicate directly with each other
question
What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
answer
Data-driven website
question
What is a primary key?
answer
A field (or group of fields) that uniquely identifies a given record in a table.
question
What is information redundancy?
answer
all of these
question
What is the physical view of information?
answer
Deals with the physical storage of information on a storage device such as a hard disk.
question
What is the primary problem with redundant information?
answer
all of these
question
What refers to how well a system can adapt to increased demands ?
answer
scalability
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraints
question
What type of website is best to build for a general informational website with static information?
answer
Static website
question
What type of website is best to build for a continually changing information, including press releases, new product information, and updated pricing?
answer
data driven website
question
Which of the following types of information can be found in a database?
answer
all of these
question
Which of the following is incorrect in reference to a database?
answer
information is accessed by physical structure
question
Which of the following is correct in reference to a database?
answer
A database can support may logical views
question
Which of the following measures how quickly a system performs a certain process or transaction?
answer
Perfromance
question
Which of the following is true in regard to eliminating redundant information?
answer
Improves information quality
question
Which of the following is a valid type of integrity constraint?
answer
Business-critial integrity constraint
question
Which of the following is not an advantage of building a data-driven website?
answer
Minimizes or reduces efficiency
question
Why do relational databases use primary keys and foreign keys?
answer
to create logical relationships
question
According to the ethical computer use policy, users should be ______________ of the rules and, by agreeing to use the system on that basis, _______________ to abide by the rules.
answer
informed; consent
question
If an organization were to have only one policy, which one would it want?
answer
Ethical computer use policy
question
What are the policies and procedures that address the ethical use of computers and Internet usage in the business environment?
answer
ePolicies
question
What are the principles and standards that guide our behavior toward other people?
answer
Ethics
question
What is a contractual stipulation that ensures that ebusiness participants do not deny their online actions?
answer
Nonrepudiation
question
What is a hardware device that captures keystrokes on their journey from the keyboard to the motherboard?
answer
Hardware key logger
question
What is a mail bomb?
answer
Sending a massive amount of email to a specific person or system that can cause that user's server to stop functioning.
question
What is a policy that a user must agree to follow in order to be provided access to a network or to the Internet?
answer
acceptable use policy
question
What is a program, when installed on a computer, records every keystroke and mouse click?
answer
key logger software
question
What is a small file deposited on a hard drive by a website containing information about customers and their web activities?
answer
cookie
question
What is intangible creative work that is embodied in physical form?
answer
Intellectual property
question
What is one of the major problems with email?
answer
Users expectation of privacy
question
What is software that is manufactured to look like the real thing and sold as such?
answer
Counterfeit software
question
What is the assurance that messages and information remain available only to those authorized to view them?
answer
Confidentiality
question
What is the ideal type of decision making for people in an organization?
answer
Logical and Ethical
question
What is the legal protection afforded an expression of an idea, such as a song, video game, and some types of proprietary documents?
answer
Copyright
question
What is the policy that contains general principles to guide computer user behavior?
answer
none of these
question
What is the right to be left alone when you want to be, to have control over your own personal possessions, and not to be observed without your consent?
answer
Privacy
question
What is the unauthorized use, duplication, distribution, or sale of copyrighted software?
answer
Pirated software
question
Which act allows any person to examine government records unless it would cause an invasion of privacy?
answer
the freedom of information act
question
Which act prohibits the use of video rental information on customers for any purpose other than that of marketing goods and services directly to the consumer?
answer
the Bork bill
question
Which act protects investors by improving the accuracy and reliability of corporate disclosures?
answer
the Sarbanes-Oxley Act
question
Which act restricts what information the federal government can collect?
answer
the Privacy act
question
Which act strengthened criminal laws governing identity theft?
answer
None of these
question
Which of the following describes privacy?
answer
The right to be left alone when you want to be, to have control over your own personal possessions, and to not be observed without your consent.
question
Which of the following is not a part of the email privacy policy stipulations?
answer
It informs people that the organization has full control over email once it is transmitted outside the organization.
question
Which of the following describes Workplace MIS monitoring?
answer
all of these
question
Which of the following describes confidentiality?
answer
The assurance that messages and information are available only to those who are authorized to view them.
question
Which of the following describes ePolicies?
answer
Policies and procedures that address the ethical use of computers and Internet usage in the business environment.
question
Which of the following is not considered an ePolicy?
answer
Security badge policy
question
Which of the following is an example of acting ethically?
answer
None of these
question
Which of the following is not included in the four quadrants of ethical and legal behavior?
answer
all of these
question
Which of the following is a classic example of unintentional information reuse?
answer
social security number
question
Which of the following is part of the acceptable use policy stipulations?
answer
all of these
question
Which of the following is part of the acceptable use policy stipulations?
answer
Not attempting to mail bomb a site
question
Which policy contains general principles regarding information privacy?
answer
information privacy policy
question
Which policy details the extent to which email messages may be read by others?
answer
email privacy policy
question
Which policy ensures that the users know how to behave at work and that the organization has a published standard through which to deal with user infractions?
answer
Ethical computer use policy
question
Which policy is it common practice for many businesses and educational facilities to require employees or students to sign before being gaining network access?
answer
acceptable use policy
question
Which policy typically contains a nonrepudiation clause?
answer
acceptable use policy
question
All of the following are characteristics of information except:
answer
Quantity
question
What are the different types of information?
answer
Levels, formats, granularities
question
What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performance of daily operational tasks?
answer
Transactional information
question
What encompasses all organizational information and its primary purpose is to support the performance of managerial analysis tasks?
answer
analytical information
question
What is a real-time system?
answer
Provides real-tiem information in response to requests
question
What is immediate, up-to-date information?
answer
Real-time information
question
What is it called when each transaction, entity, and event is represented only once in the information?
answer
Uniqueness
question
What is one of the biggest pitfalls associated with real-time information?
answer
It continually changes
question
What provides real-time information in response to requests?
answer
Real-time systems
question
Which of the following represents the different information levels?
answer
Individual, departement, enterprise
question
Which of the following represents the different information formats?
answer
Documents, presentation, spreadsheet, database
question
Which of the following represents the different information granularities?
answer
Detail, summary, aggregate
question
Which of the following is an example of transactional information?
answer
all of these
question
Which of the following is an example of transactional information?
answer
Purchasing stocks
question
Which of the following is not one of the five characteristics common to high-quality information?
answer
Quantity
question
Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
Which of the following implies that information is current with respect to the business requirement?
answer
Timeliness
