ISDS 3110 FINAL EXAM GUIDE Practice Questions 130+ & 100% Correct
Answers,2026
A company is analyzing customer transaction data and notices that duplicate
records are inflating total revenue figures. Which data quality issue is being
observed, and what is the best corrective action?
A. Missing data; impute values
B. Duplicate data; remove redundant records
C. Outliers; normalize data
D. Inconsistent data; standardize formats
Answer: B
Rationale:
Duplicate records lead to inaccurate aggregation results. Removing duplicates
ensures accurate reporting and analysis.
A business wants to forecast next quarter’s sales using historical trends and
seasonal patterns. Which technique is most appropriate?
1
,A. Clustering
B. Time-series analysis
C. Association rules
D. Classification
Answer: B
Rationale:
Time-series analysis is specifically designed for forecasting data over time,
accounting for trends and seasonality.
A data analyst wants to reduce the number of variables in a dataset while
retaining most of the information. Which method should be used?
A. Regression
B. PCA (Principal Component Analysis)
C. Clustering
D. Classification
Answer: B
Rationale:
2
,PCA reduces dimensionality while preserving variance in the data.
A company is implementing a system that integrates data from multiple sources
and provides analytical tools for managers. What type of system is this?
A. Transaction Processing System
B. Decision Support System
C. Executive Information System
D. Office Automation System
Answer: B
Rationale:
DSS integrates data and analytical tools to support managerial decision-making.
A database contains a table with repeated groups of data, violating normalization
rules. What is the best approach?
A. Denormalize further
B. Apply normalization techniques
C. Delete the table
3
, D. Ignore the issue
Answer: B
Rationale:
Normalization removes redundancy and improves data integrity.
A company implements role-based access control. What is the main benefit?
A. Faster processing
B. Restricting access based on user roles
C. Increased storage
D. Better visualization
Answer: B
Rationale:
Role-based access ensures users can only access data relevant to their role.
A data scientist evaluates a classification model using precision and recall. What is
the focus of these metrics?
4
Answers,2026
A company is analyzing customer transaction data and notices that duplicate
records are inflating total revenue figures. Which data quality issue is being
observed, and what is the best corrective action?
A. Missing data; impute values
B. Duplicate data; remove redundant records
C. Outliers; normalize data
D. Inconsistent data; standardize formats
Answer: B
Rationale:
Duplicate records lead to inaccurate aggregation results. Removing duplicates
ensures accurate reporting and analysis.
A business wants to forecast next quarter’s sales using historical trends and
seasonal patterns. Which technique is most appropriate?
1
,A. Clustering
B. Time-series analysis
C. Association rules
D. Classification
Answer: B
Rationale:
Time-series analysis is specifically designed for forecasting data over time,
accounting for trends and seasonality.
A data analyst wants to reduce the number of variables in a dataset while
retaining most of the information. Which method should be used?
A. Regression
B. PCA (Principal Component Analysis)
C. Clustering
D. Classification
Answer: B
Rationale:
2
,PCA reduces dimensionality while preserving variance in the data.
A company is implementing a system that integrates data from multiple sources
and provides analytical tools for managers. What type of system is this?
A. Transaction Processing System
B. Decision Support System
C. Executive Information System
D. Office Automation System
Answer: B
Rationale:
DSS integrates data and analytical tools to support managerial decision-making.
A database contains a table with repeated groups of data, violating normalization
rules. What is the best approach?
A. Denormalize further
B. Apply normalization techniques
C. Delete the table
3
, D. Ignore the issue
Answer: B
Rationale:
Normalization removes redundancy and improves data integrity.
A company implements role-based access control. What is the main benefit?
A. Faster processing
B. Restricting access based on user roles
C. Increased storage
D. Better visualization
Answer: B
Rationale:
Role-based access ensures users can only access data relevant to their role.
A data scientist evaluates a classification model using precision and recall. What is
the focus of these metrics?
4
