ISDS 3110 FINAL EXAM GUIDE Practice Questions & 100% Correct Answers,2026
A large retail company is analyzing customer purchase data stored across multiple
systems. The data is inconsistent, duplicated, and contains missing values. Before
performing any predictive analytics, what is the most appropriate first step in the
data analytics process?
A. Build a machine learning model
B. Perform data cleaning and preprocessing
C. Visualize the raw data
D. Deploy a dashboard
Answer: B
Rationale:
Data cleaning and preprocessing are essential to ensure data quality. Without
removing duplicates, handling missing values, and standardizing formats, any
analysis or model built would produce unreliable results.
1
,A business analyst is designing a decision support system (DSS) to help managers
evaluate different pricing strategies. Which component of the DSS is responsible
for running simulations and “what-if” analyses?
A. Database management system
B. Model management system
C. User interface
D. Transaction processing system
Answer: B
Rationale:
The model management component handles analytical tools, algorithms, and
simulations, enabling users to evaluate different scenarios.
An organization wants to ensure that only authorized users can access sensitive
financial data. Which information security principle is being addressed?
A. Availability
B. Integrity
C. Confidentiality
2
, D. Scalability
Answer: C
Rationale:
Confidentiality ensures that information is accessible only to authorized
individuals.
A company implements a system that processes customer orders in real time,
updating inventory immediately. What type of system is this?
A. Decision Support System
B. Transaction Processing System (TPS)
C. Executive Information System
D. Data Warehouse
Answer: B
Rationale:
TPS handles routine, day-to-day operations such as order processing and
inventory updates in real time.
3
A large retail company is analyzing customer purchase data stored across multiple
systems. The data is inconsistent, duplicated, and contains missing values. Before
performing any predictive analytics, what is the most appropriate first step in the
data analytics process?
A. Build a machine learning model
B. Perform data cleaning and preprocessing
C. Visualize the raw data
D. Deploy a dashboard
Answer: B
Rationale:
Data cleaning and preprocessing are essential to ensure data quality. Without
removing duplicates, handling missing values, and standardizing formats, any
analysis or model built would produce unreliable results.
1
,A business analyst is designing a decision support system (DSS) to help managers
evaluate different pricing strategies. Which component of the DSS is responsible
for running simulations and “what-if” analyses?
A. Database management system
B. Model management system
C. User interface
D. Transaction processing system
Answer: B
Rationale:
The model management component handles analytical tools, algorithms, and
simulations, enabling users to evaluate different scenarios.
An organization wants to ensure that only authorized users can access sensitive
financial data. Which information security principle is being addressed?
A. Availability
B. Integrity
C. Confidentiality
2
, D. Scalability
Answer: C
Rationale:
Confidentiality ensures that information is accessible only to authorized
individuals.
A company implements a system that processes customer orders in real time,
updating inventory immediately. What type of system is this?
A. Decision Support System
B. Transaction Processing System (TPS)
C. Executive Information System
D. Data Warehouse
Answer: B
Rationale:
TPS handles routine, day-to-day operations such as order processing and
inventory updates in real time.
3