IS290 Test 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
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 of the following represents market basket analysis?
answer
Analyzes website information Detects customers' buying behavior Analyzes checkout scanner information ***All of the above
question
What is time-series information?
answer
Time-stamped information collected at a particular frequency
question
Which of the following is a form of statistical analysis?
answer
Forecasting
question
What are forecasts?
answer
Predictions made on the basis of time-series information
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 of the following is not one of the parallels between challenges in business and those of war?
answer
Using tactical business intelligence
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 predicting machinery failures and finding key factors that control optimization of manufacturing capacity?
answer
Operations management 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
Which of the following is the result of BI that implies that the data have been documented as the certified or approved data for the enterprise?
answer
Reliable
question
Which of the following is the result of BI that the processes that deliver the data to the business community are well documents and there are no surprises such as missing or inaccurate data?
answer
Consistent
question
Which of the following is the result of BI that the data have been defined in business terms and calculations and algorithms are easily accessed for comprehension?
answer
Understandable
question
Which of the following is the result of BI that it is no longer required to have a PhD in statistics to get sophisticated analytics delivered to users' fingertips?
answer
Easily manipulated
question
Which type of BI manages daily operations and integrates BI with operational systems?
answer
Operational BI
question
Which type of BI conducts short-term analysis to achieve strategic goals?
answer
Tactical BI
question
Which type of BI achieves long-term organizational goals?
answer
Strategic BI
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
What is data latency?
answer
The time duration to make data ready for analysis and loading the data into the database
question
What is analysis latency?
answer
The time from which data are made available to the time when analysis is complete
question
What is decision latency?
answer
The time it takes a human to comprehend the analytic results and determine an appropriate action
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 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 benefits
question
What are the different types of information?
answer
Levels, formats, granularities
question
Which of the following represents the different information levels?
answer
Individual, department, enterprise
question
Which of the following represents the different information formats?
answer
Document, presentation, spreadsheet, database
question
Which of the following represents the different information granularities?
answer
Detail, summary, aggregate
question
All of the following are characteristics of information except
answer
Quantity
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
Which of the following is an example of transactional information?
answer
Making an airline reservations Purchasing stock Withdrawing cash from an ATM All of these
question
________________ achieved great success by managing information, while _________ was unsuccessful at managing information.
answer
Samsung Electronics, Staples
question
What encompasses all organizational information and its primary purpose is to support the performance of managerial analysis tasks?
answer
Analytical information
question
Which of the following is an example of transactional information?
answer
Sales projection ***Purchasing stock Trend projection All of these
question
What is immediate, up-to-date information?
answer
Real-time information
question
What provides real-time information in feedback to query requests?
answer
Real-time systems
question
What is one of the biggest pitfalls associated with real-time information?
answer
It continually changes
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
question
What is it called when each transaction, entity, and event is represented only once in the information?
answer
Uniqueness
question
What is a real-time system?
answer
Provides real-time information in feedback to query requests.
question
Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?
answer
Hierarchical database
question
Which of the following database structures offers a flexible way of representing objects and their relationships?
answer
Network database
question
In the relational database model, what are characteristics or properties of an entity?
answer
Attribute
question
What are characteristics or properties of an entity called?
answer
Attributes Fields Columns ** All of the above
question
Why do relational databases use primary keys and foreign keys?
answer
To create logical relationships
question
Which of the following is incorrect in reference to a database?
answer
Information is accessed by physical structure
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
Which of the following is correct in reference to a database?
answer
A database can support many logical views
question
What refers to how well a system can adapt to increased demands?
answer
Scalability
question
Which of the following measures how quickly a system performs a certain process or transaction?
answer
Performance
question
What is information redundancy?
answer
Storing duplicate information in multiple places Duplication of information Storing the same information in multiple places ***All of the Above
question
Which of the following is true in regards to the elimination of redundant information?
answer
Improves information quality
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 constraint
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraint
question
None of the following are business-critical integrity constraints, except:
answer
System will not allow returns of fresh produce after 15 days past delivery
question
Which of the following uses a DBMS to interact with a database?
answer
Users of marketing programs ***All of the above Users of human resource programs Users of accounting programs
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 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 website with continually changing information including press releases, new product information, and updated pricing?
answer
Data-driven website
question
Which of the following is not an advantage of building a data-driven website?
answer
Minimizes or reduces efficiency
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 a backward integration?
answer
Takes information entered into a given system and sends it automatically to all upstream systems and processes
question
What is an integration?
answer
Allows separate systems to communicate directly with each other
question
All of the following are reasons why operational systems are not appropriate for business analysis, except:
answer
Operational systems are integrated
question
Which of the following describes ETL?
answer
A process that loads information into a data warehouse A process that transforms information using a common set of enterprise definitions ***All of the above A process that extracts information from internal and external databases
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 statements is true regarding customer information?
answer
Customer information can exist in several operational systems Customer information in each operational system could change Customer information in each operational system can be different ***All of the above
question
Which of the following occurs during data cleansing?
answer
***All of the above Clean missing records Clean inaccurate data Clean redundant records
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
What is information that people use to support their decision-making efforts?
answer
Business intelligence
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
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
Decide key business issues Make projections Identify trends ***All of the above
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 solution?
answer
Build a data mart
question
What is a dimension?
answer
A particular attribute of information
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
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 versus completeness
question
Which of the following are the principle BI enablers?
answer
Technology, people, and corporate culture
question
What can a model accomplish?
answer
***All of the above Manipulate time Understand uncertainty Calculate risks
question
What is the study of the impact that changes in one (or more) parts of the model have on other parts of the model?
answer
Sensitivity analysis
question
What finds the inputs necessary to achieve a goal, such as a desired level of output?
answer
Goal-seeking analysis
question
What is consolidation?
answer
Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information
question
What integrates information from multiple components and tailors the information to individual preferences?
answer
Digital dashboard
question
What are various commercial applications of artificial intelligence?
answer
Intelligent system
question
What is a category of AI that attempts to emulate the way the human brain works?
answer
Neural network
question
Which of the following is the most commonly used form of AI in the business arena?
answer
Expert system
question
What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem?
answer
Genetic algorithm
question
Which of the following represents the top-down (executives to analysts) organizational levels of information technology systems?
answer
EIS, DSS, TPS
question
Which of the following is a type of transaction processing system?
answer
Order processing
question
Which of the following is a type of decision support system?
answer
Manufacturing
question
Which company has "The Wall of Shaygan", which is a digital dashboard that tracks 100-plus IT systems on a single screen?
answer
Verizon Communications
question
Which company offers a strategic business information service using artificial intelligence that enables organizations to track the product offering, pricing policies, and promotions of online competitors?
answer
RivalWatch
