ISDS 3110 FINAL EXAM GUIDE Practice Questions 100+ & 100% Correct
Answers,2026
A company is building a data warehouse and must decide how to structure data
for efficient querying and reporting. Which schema design is most appropriate for
simplifying queries and improving performance?
A. Hierarchical schema
B. Network schema
C. Star schema
D. Flat file structure
Answer: C
Rationale:
A star schema organizes data into fact and dimension tables, making queries
simpler and faster for analytical purposes.
A business analyst notices that certain variables in a dataset have vastly different
scales, which affects the performance of machine learning algorithms. What is the
best solution?
1
,A. Delete the variables
B. Normalize or standardize the data
C. Ignore the issue
D. Increase dataset size
Answer: B
Rationale:
Normalization or standardization ensures variables are on similar scales,
improving model performance.
A company wants to determine whether there is a statistically significant
relationship between advertising spend and sales. Which method should be used?
A. Clustering
B. Hypothesis testing
C. Classification
D. Association rules
Answer: B
Rationale:
2
,Hypothesis testing evaluates whether relationships between variables are
statistically significant.
A manager uses a system that integrates internal data with external market data
to support strategic decisions. What type of system is this?
A. TPS
B. DSS
C. OLTP
D. Spreadsheet
Answer: B
Rationale:
Decision Support Systems integrate multiple data sources to assist in complex
decision-making.
A data scientist uses a confusion matrix to evaluate a classification model. What
does it measure?
A. Data storage
3
, B. Model performance across predicted vs. actual values
C. Data visualization
D. Data cleaning
Answer: B
Rationale:
A confusion matrix shows true positives, false positives, true negatives, and false
negatives.
A company stores sensitive customer data and implements multi-factor
authentication. What is the main purpose?
A. Increase processing speed
B. Enhance security and access control
C. Reduce storage
D. Improve visualization
Answer: B
Rationale:
Multi-factor authentication adds an extra layer of security beyond passwords.
4
Answers,2026
A company is building a data warehouse and must decide how to structure data
for efficient querying and reporting. Which schema design is most appropriate for
simplifying queries and improving performance?
A. Hierarchical schema
B. Network schema
C. Star schema
D. Flat file structure
Answer: C
Rationale:
A star schema organizes data into fact and dimension tables, making queries
simpler and faster for analytical purposes.
A business analyst notices that certain variables in a dataset have vastly different
scales, which affects the performance of machine learning algorithms. What is the
best solution?
1
,A. Delete the variables
B. Normalize or standardize the data
C. Ignore the issue
D. Increase dataset size
Answer: B
Rationale:
Normalization or standardization ensures variables are on similar scales,
improving model performance.
A company wants to determine whether there is a statistically significant
relationship between advertising spend and sales. Which method should be used?
A. Clustering
B. Hypothesis testing
C. Classification
D. Association rules
Answer: B
Rationale:
2
,Hypothesis testing evaluates whether relationships between variables are
statistically significant.
A manager uses a system that integrates internal data with external market data
to support strategic decisions. What type of system is this?
A. TPS
B. DSS
C. OLTP
D. Spreadsheet
Answer: B
Rationale:
Decision Support Systems integrate multiple data sources to assist in complex
decision-making.
A data scientist uses a confusion matrix to evaluate a classification model. What
does it measure?
A. Data storage
3
, B. Model performance across predicted vs. actual values
C. Data visualization
D. Data cleaning
Answer: B
Rationale:
A confusion matrix shows true positives, false positives, true negatives, and false
negatives.
A company stores sensitive customer data and implements multi-factor
authentication. What is the main purpose?
A. Increase processing speed
B. Enhance security and access control
C. Reduce storage
D. Improve visualization
Answer: B
Rationale:
Multi-factor authentication adds an extra layer of security beyond passwords.
4
