NEW
Font size
WorksheetsIS101-Summative-Topic 8 and 9
Total questions: 58
Worksheet time: 39mins
In the DIKW hierarchy, which level best describes organized sales totals (e.g., daily sales per branch) that begin to show meaning and context?
Data
Information
Knowledge
Wisdom
Metadata
According to the DIKW model described in Chapter 8, which of the following is an example of “wisdom”?
Raw transaction logs from POS terminals
A bar chart showing lunchtime sales by item
A decision to create a value meal pairing based on combined sales patterns
A cleaned dataset of customer emails
A data warehouse table of products
Which component is identified as the primary process for making raw data ready for analysis in a BI system?
OLAP
ETL (Extract, Transform, Load)
Data mining
Dashboarding
Transaction processing
Which BI technology enables multidimensional exploration of data across time, geography, and product categories?
OLTP
OLAP
CRM
ERP
EDI
There were several BI applications discussed in Chapter 8. Which use case is explicitly associated with HR in the BI examples?
Route planning
Workforce analytics and employee attrition analysis
Real-time stock trading
Mobile ticketing
Digital goods trading
In the MarketXYZ case exercise, which benefit was reported after BI implementation?
50% reduction in inventory
15% increase in customer retention
100% elimination of staff resistance
Complete removal of legacy systems
Doubling of product lines
Which challenge of BI implementation is explicitly listed in the chapter as a common obstacle?
Universal compatibility of legacy systems
Data quality and inconsistency
Lack of any suitable BI vendors
Excessively simple regulatory requirements
Overabundance of trained personnel
Which future trend in BI refers to systems that let non-technical users create their own reports?
Augmented analytics
Self-service BI
In-memory computing
Distributed databases
Data fragmentation
Which BI component is primarily responsible for visualizing insights for executives?
Data warehouse
ETL pipeline
Dashboards and visualization tools
Data fragmentation module
Transaction processor
In the BI workflow described, what follows after data is loaded into the data warehouse and cleaned?
Direct printing of raw logs
Immediate shutdown of OLAP engines
Application of data mining techniques to uncover patterns
Manual filing of reports
Archival without analysis
Which is an explicitly stated limitation of mobile commerce (m‑commerce) that can affect BI mobile dashboards?
Unlimited storage space
Short battery life and small‑screen challenges
Guaranteed offline operation
Faster processing than desktops
No reliance on third parties
Which business domain example in the BI chapter showed how BI optimized delivery routes and reduced costs?
Netflix content recommendations
Starbucks mobile offers
United Parcel Service (UPS) route optimization
Spotify playlist generation
Amul dairy distribution
It defines data mining as most directly useful for which BI purpose?
Printing invoices
Uncovering customer behavior and product affinities
Encrypting payment gateways
Creating transactional ACID guarantees
Scheduling employee vacations
Which of the following BEST describes “augmented analytics” as listed in the BI chapter?
A technique for physically expanding data centers
Use of AI to automate data preparation and generate insights using natural language
Manual report creation by IT only
A method to replace dashboards with spreadsheets
A networking protocol for ETL
Which BI challenge is most directly addressed by a governance framework and regular data cleansing?
Integration with cloud providers
Data quality issues
Mobile app responsiveness
Battery life constraints
Payment gateway failures
Which of the following is a key advantage of business intelligence in finance, as discussed in the chapter?
Slower reporting cycles
More accurate financial forecasting and early risk identification
Increased manual paperwork
Hiding portfolio performance from stakeholders
Preventing data‑driven decision‑making
When we say “real‑time analytics,” what primary BI capability is being emphasized?
Ability to process and act on information as it is generated for instant decision‑making
Creation of only weekly printed reports
Removal of OLAP functionality
Using only legacy databases
Replacing dashboards with email alerts only
In the BI data model, which table contains attributes such as BranchID, BranchName, Region, and ManagerName?
Customers
Sales
Branches
Products
Promotions
There are several components of BI. Which one is described as the centralized repository optimized for querying and analysis?
Data source
Data warehouse
Transaction processor
POS terminal
User interface
In Chapter 9, which system type is primarily designed to support routine, structured tasks with scheduled reporting?
Decision Support System (DSS)
Management Information System (MIS)
Group Decision Support System (GSS)
Executive Support System (ESS)
Knowledge‑based DSS
Which of the following is a defining goal of a Decision Support System (DSS)?
To replace managers in all decisions
To assist in semi‑structured or unstructured decision‑making tasks using models and analysis
To only produce printed invoices monthly
To handle only transaction processing for payroll
To function exclusively offline
The Herbert Simon decision‑making model stages listed include:
Plan, Execute, Archive
Intelligence, Design, Choice
Data, Wisdom, Archive
Input, Output, Disposal
Collect, Store, Delete
Which component of a DSS contains mathematical, statistical, and financial models for analysis?
Dialogue manager (UI)
Model base
DSS database
Transaction log
Knowledge repository only
Which DSS component is described as the interaction bridge between the user and the system?
Model base
Database server hardware
Dialogue manager (user interface)
Transaction processor
ETL pipeline
Which type of support system is explicitly aimed at senior executives and provides high‑level summarized, often real‑time information?
MIS
DSS
GSS
ESS (Executive Support System)
OLAP server
In comparing MIS and DSS , which statement is true?
MIS handles unstructured problems while DSS handles scheduled printed reports.
MIS is primarily oriented to printed reports on a schedule; DSS supports unstructured/semi‑structured problem solving with interactive analysis.
MIS uses dashboards only; DSS uses only print.
MIS always replaces the decision maker; DSS never assists decision‑makers.
MIS requires model bases; DSS does not.
It was mentioned that a knowledge‑based component is for DSS. What is the main benefit of adding expert system features to a DSS?
Makes the system slower
Enhances reasoning and provides recommendations or diagnoses in complex scenarios
Removes the need for any user interface
Converts OLAP to OLTP
Replaces data warehouses entirely
Which group‑oriented system is intended to improve collaborative decision‑making for teams?
ESS
MIS
GSS (Group Decision Support System)
OLAP cube
ETL tool
Which of the following techniques is explicitly mentioned in the DSS chapter as something the model base supports?
What‑if simulations and forecasting
Manual ledger balancing only
Printing deposit slips
Creating POS receipts
Basic word processing
In the BI chapter, which of these is listed as an operational threat that can disrupt e‑commerce and affect BI data feeds?
Data visualizations
System downtime
Dashboards
OLAP servers
In‑memory databases
The BI chapter lists “personalization” as a benefit. Which technology or approach directly enables personalized recommendations (as illustrated by Netflix, Amazon, Spotify)?
Static printed reports
Data mining and predictive analytics
Fax machines
Manual phone surveys only
Barcode scanners alone
According to the BI chapter, which of the following is an example of a “content provider” m‑commerce model?
A mobile wallet processing payments for in‑store purchases
A streaming service offering subscription access to music or video
An EDI link between suppliers
A government procurement portal
A warehouse inventory system
Which BI challenge in the chapter is most directly linked to difficulties when integrating with older organizational systems?
Data quality concerns only
Integration with legacy systems
Short battery life of devices
Customer resistance to discounts
Too many mobile apps
The BI implementation strategies list “prioritize security and privacy.” Which control did the text explicitly mention as part of that strategy?
Removing encryption to speed up queries
Use of encryption and multi-factor authentication plus regular audits
Making all data public for transparency
Disabling logging to reduce storage use
Avoiding compliance with regulations
Which BI tool is identified as commonly used for dashboards and visualization?
Cobol reports
Microsoft Power BI or Tableau
Fax machine interfaces
Manual chalkboards
EDI VAN only
In Chapter 9’s discussion of components, the DSS database is expected to connect to which of the following to provide more information?
Only internal flat files with no external links
External databases, data warehouses, cloud storage, or live transaction systems
Only printed ledgers
Only third-party social media platforms without filtering
Only Excel spreadsheets saved on desktop
It describes the CAP theorem context when discussing NoSQL in earlier chapters. Within the DSS/BI context, NoSQL’s relaxed consistency model is referred to as which philosophy?
ACID
BASE (Basically Available, Soft state, Eventually consistent)
OLTP
ETL
TCP/IP
Which of the following is an explicit benefit of in-memory databases referenced in the materials that could speed BI analytics?
Increased mechanical latency
Sub-millisecond query response times due to direct memory access
Complete elimination of persistence mechanisms
Removal of multicore optimization
Making durability impossible
According to the BI chapter, what is a likely measurable result of successful inventory optimization using BI?
Higher stockouts and lower turnover
Improved stock availability and higher inventory turnover
Increased manual counting work
Less accurate sales forecasting
Elimination of customer retention tracking
In the description of DSS, which optional component helps DSS provide reasoning similar to an expert?
Transaction processor
Knowledge-based system (expert system features)
Simple HTML interface only
Manual logbooks
Paper-based decision trees only
Which of the following best describes the “dialogue manager” in a DSS?
The underlying database engine for OLTP transactions
The user interface allowing users to input data, choose models, and view results
A physical meeting room for decision-makers
A separate ERP module for payroll only
A hardware device for data replication
The BI examples include a retailer discovering that electronics sell best in urban centers during holiday seasons. Which BI component would most likely surface this insight?
Raw transaction log files without transformation
OLAP analysis on a standardized data warehouse after ETL
Faxing sales records to executives
Manual tallying of paper receipts only
Backup tapes
In Chapter 9, which support system is explicitly designed to facilitate collaboration in groups, sometimes face-to-face or remote?
MIS
GSS (Group Decision Support System)
OLTP engine
Legacy EDI system
In-memory DB only
Which decision-making phase in Simon’s model involves defining problems and examining the environment?
Choice
Design
Implementation
Intelligence
Monitoring
According to Chapter 9, which system type is mainly responsible for delivering the “right information to the right person at the right time” for operational and management reporting?
DSS
MIS
GSS
ESS
Data warehouse only
Which of these is listed as a common DSS technique for exploring alternatives and their consequences?
What-if simulations
Only printed checklists
Manual filing systems
Paper-based flowcharts exclusively
Ledger balancing without models
The BI chapter emphasizes “personalized customer engagement.” Which dataset attribute from the BI data model most directly supports segmentation by customer lifetime?
PromoID only
JoinDate and LoyaltyPoints in the Customers table
Branch OpenDate only
Product ReorderLevel only
InventoryID only
Which BI trend in the chapter promises automatic insight generation using AI and reduces manual data preparation?
Static BI reporting
Augmented analytics
Manual ETL scripting only
Printed monthly ledgers
Legacy data silos
In the DSS discussion, which architectural model describes a system where nodes are equal and share responsibilities?
Client-server model only
Peer-to-peer model
Centralized mainframe model only
ETL-only architecture
Single-node OLAP cube
Which BI key area for long-term success aims to ensure a consistent experience across the website and mobile app?
Prioritize security and privacy only
Improve user experience and adopt omnichannel approaches
Remove mobile apps to focus only on desktop
Limit payment options to cash only
Avoid personalization to reduce complexity
In the BI data model, which table is most appropriate to query when building a promotion effectiveness dashboard that shows sales uplift by promo?
TimeDimension only
Promotions joined with Sales and Products tables
Suppliers only
Branches only
Inventory only
Which challenge in distributed databases is also relevant to DSS when ensuring multiple copies remain synchronized?
Data fragmentation only
Data consistency and synchronization across replicas
Use of paper files only
Single-threaded processing exclusively
Elimination of concurrency control
It describes “self-service BI” as empowering users. Which group benefits most directly from this capability?
Only database administrators
Non-technical business users who want to create reports and dashboards independently
Only hardware vendors
Only the accounting department with no BI interest
Only third-party logistics providers
Which of the following is an explicitly recommended strategy in the BI chapter to strengthen logistics and fulfillment?
Reducing inventory tracking to manual counts only
Investing in reliable couriers, automated inventory, and real-time tracking
Eliminating real-time alerts to reduce load
Using fax confirmations for shipments exclusively
Avoiding integration with courier systems
In Chapter 9, what role does the model base play during what-if analysis?
It stores only raw log files with no analytical models
It provides mathematical and simulation models to evaluate alternative scenarios
It simply prints templates for human analysis
It functions as a user interface only
It archives completed reports without analysis
Which BI challenge mentioned can be mitigated by clear communication, training, and leadership support during rollout?
Hardware capacity only
User resistance to technology (change management)
Elimination of dashboards entirely
Permanent removal of ETL processes
Making all reports print-only
According to the materials, what is an immediate operational advantage of in-memory databases for BI workloads?
Increased disk I/O latency
Millisecond or microsecond response times enabling real-time analytics
Obliteration of durability guarantees always
Requirement to avoid compression techniques
Increase in manual report generation time
In the comparison table of support systems (MIS, DSS, ESS), which characteristic distinguishes ESS from MIS and DSS?
ESS is oriented toward low-level transactional printing only
ESS provides high-level, summarized, and strategic information for senior executives with a big-picture view and real-time monitoring
ESS always handles daily payroll processing only
ESS is unable to integrate external data sources
ESS is designed exclusively for OLTP workloads
