MIST 4630 FINAL EXAM PREPARATION 2025”2026 LATEST VERSION
150 QUESTIONS AND CORRECT ANSWERS WITH RATIONALES
COVERING MOST TESTED QUESTIONS GUARANTEE OVER 80%
PASSMARK
1. Which of the following best describes the purpose of an ERP system in an organization?
☐ A. To manage only the financial transactions of the company
☑ B. To integrate core business processes across various departments
☐ C. To replace all manual labor in the company
☐ D. To manage only the human resources functions
Rationale: ERP (Enterprise Resource Planning) systems integrate multiple business processes—
finance, HR, production, and supply chain—into a single system for better coordination and
efficiency.
2. In a data warehouse, what is the primary purpose of ETL (Extract, Transform, Load)?
☑ A. To extract data from multiple sources, transform it, and load it into a central repository
☐ B. To encrypt sensitive data for security purposes
☐ C. To store transactional data in real-time
☐ D. To generate operational reports for daily use
Rationale: ETL processes allow organizations to consolidate data from multiple sources, clean
and transform it, and store it in a data warehouse for analysis and decision-making.
3. A company wants to improve decision-making by analyzing customer purchasing patterns.
Which analytics approach is most appropriate?
☐ A. Descriptive analytics
☑ B. Predictive analytics
☐ C. Prescriptive analytics
☐ D. Operational analytics
Rationale: Predictive analytics uses historical data to identify patterns and forecast future
outcomes, which helps businesses anticipate customer behavior.
4. Which of the following is a key advantage of cloud computing?
☐ A. Guaranteed zero downtime
☑ B. Scalability of resources on-demand
,☐ C. Complete elimination of IT staff
☐ D. No need for data security measures
Rationale: Cloud computing allows organizations to scale computing resources up or down
depending on demand, providing flexibility and cost efficiency.
5. In a project management context, which technique is used to identify the longest path of
dependent tasks that determine the minimum project duration?
☑ A. Critical Path Method (CPM)
☐ B. Gantt Chart
☐ C. SWOT Analysis
☐ D. Six Sigma
Rationale: CPM identifies critical tasks that affect the project completion time, helping
managers prioritize resources effectively.
6. What is the main purpose of a business intelligence (BI) dashboard?
☐ A. To store raw transactional data
☑ B. To provide real-time visualization of key performance indicators (KPIs)
☐ C. To encrypt data for security
☐ D. To perform ETL operations
Rationale: BI dashboards present key metrics in an easily digestible visual format to help
stakeholders monitor performance and make informed decisions.
7. Which type of database design organizes data into tables with rows and columns and
enforces relationships between tables?
☑ A. Relational database
☐ B. NoSQL database
☐ C. Object-oriented database
☐ D. Flat-file database
Rationale: Relational databases structure data into tables and define relationships between
them, allowing for structured queries and data integrity.
8. Which of the following best describes Big Data characteristics known as the “3 Vs”?
☑ A. Volume, Velocity, Variety
,☐ B. Value, Verification, Variance
☐ C. Velocity, Validation, Veracity
☐ D. Volume, Verification, Versioning
Rationale: Big Data is commonly characterized by the 3 Vs: Volume (large amounts of data),
Velocity (speed of data processing), and Variety (different types of data).
9. In IT governance, COBIT primarily focuses on:
☑ A. Aligning IT processes with business objectives and managing risks
☐ B. Programming standards for software developers
☐ C. Designing database architectures
☐ D. Employee training programs
Rationale: COBIT (Control Objectives for Information and Related Technology) provides a
framework for IT governance, ensuring IT supports business goals and manages risks effectively.
10. Which scenario best exemplifies prescriptive analytics?
☐ A. Analyzing past sales to determine monthly revenue
☐ B. Creating dashboards for KPIs
☑ C. Recommending marketing strategies based on predicted customer responses
☐ D. Recording transactions in the ERP system
Rationale: Prescriptive analytics goes beyond predicting outcomes by recommending actions to
optimize results.
11. What is the primary purpose of master data management (MDM)?
☐ A. To store temporary transaction data
☑ B. To ensure consistency, accuracy, and accountability of key business data across systems
☐ C. To replace ETL processes
☐ D. To generate predictive models
Rationale: MDM establishes a single, trusted source of key business entities (like customers or
products) to reduce data redundancy and improve decision-making.
12. Which type of IT security control restricts access to systems based on user roles?
☐ A. Detective control
☑ B. Access control
, ☐ C. Corrective control
☐ D. Physical control
Rationale: Access control ensures that users can only access information and perform actions
allowed by their role, protecting sensitive data from unauthorized access.
13. Which methodology emphasizes iterative development, frequent collaboration, and
flexible responses to change?
☐ A. Waterfall
☑ B. Agile
☐ C. PRINCE2
☐ D. Six Sigma
Rationale: Agile is an iterative, incremental approach that prioritizes collaboration, flexibility,
and continuous delivery.
14. In supply chain management, which concept focuses on minimizing inventory while
meeting customer demand?
☐ A. Just-in-Case (JIC)
☑ B. Just-in-Time (JIT)
☐ C. Material Requirements Planning (MRP)
☐ D. Enterprise Resource Planning (ERP)
Rationale: JIT aims to reduce waste and holding costs by producing and delivering goods exactly
when needed.
15. Which of the following best describes a SaaS (Software as a Service) model?
☑ A. Software is hosted in the cloud and accessed via a web browser
☐ B. Software is installed on local machines and managed by internal IT staff
☐ C. Users purchase a perpetual license and maintain updates themselves
☐ D. Users receive source code to modify as needed
Rationale: SaaS delivers software over the internet, eliminating the need for local installation
and maintenance.
16. Which technique is used to evaluate risks by considering both likelihood and impact?
☐ A. SWOT analysis
150 QUESTIONS AND CORRECT ANSWERS WITH RATIONALES
COVERING MOST TESTED QUESTIONS GUARANTEE OVER 80%
PASSMARK
1. Which of the following best describes the purpose of an ERP system in an organization?
☐ A. To manage only the financial transactions of the company
☑ B. To integrate core business processes across various departments
☐ C. To replace all manual labor in the company
☐ D. To manage only the human resources functions
Rationale: ERP (Enterprise Resource Planning) systems integrate multiple business processes—
finance, HR, production, and supply chain—into a single system for better coordination and
efficiency.
2. In a data warehouse, what is the primary purpose of ETL (Extract, Transform, Load)?
☑ A. To extract data from multiple sources, transform it, and load it into a central repository
☐ B. To encrypt sensitive data for security purposes
☐ C. To store transactional data in real-time
☐ D. To generate operational reports for daily use
Rationale: ETL processes allow organizations to consolidate data from multiple sources, clean
and transform it, and store it in a data warehouse for analysis and decision-making.
3. A company wants to improve decision-making by analyzing customer purchasing patterns.
Which analytics approach is most appropriate?
☐ A. Descriptive analytics
☑ B. Predictive analytics
☐ C. Prescriptive analytics
☐ D. Operational analytics
Rationale: Predictive analytics uses historical data to identify patterns and forecast future
outcomes, which helps businesses anticipate customer behavior.
4. Which of the following is a key advantage of cloud computing?
☐ A. Guaranteed zero downtime
☑ B. Scalability of resources on-demand
,☐ C. Complete elimination of IT staff
☐ D. No need for data security measures
Rationale: Cloud computing allows organizations to scale computing resources up or down
depending on demand, providing flexibility and cost efficiency.
5. In a project management context, which technique is used to identify the longest path of
dependent tasks that determine the minimum project duration?
☑ A. Critical Path Method (CPM)
☐ B. Gantt Chart
☐ C. SWOT Analysis
☐ D. Six Sigma
Rationale: CPM identifies critical tasks that affect the project completion time, helping
managers prioritize resources effectively.
6. What is the main purpose of a business intelligence (BI) dashboard?
☐ A. To store raw transactional data
☑ B. To provide real-time visualization of key performance indicators (KPIs)
☐ C. To encrypt data for security
☐ D. To perform ETL operations
Rationale: BI dashboards present key metrics in an easily digestible visual format to help
stakeholders monitor performance and make informed decisions.
7. Which type of database design organizes data into tables with rows and columns and
enforces relationships between tables?
☑ A. Relational database
☐ B. NoSQL database
☐ C. Object-oriented database
☐ D. Flat-file database
Rationale: Relational databases structure data into tables and define relationships between
them, allowing for structured queries and data integrity.
8. Which of the following best describes Big Data characteristics known as the “3 Vs”?
☑ A. Volume, Velocity, Variety
,☐ B. Value, Verification, Variance
☐ C. Velocity, Validation, Veracity
☐ D. Volume, Verification, Versioning
Rationale: Big Data is commonly characterized by the 3 Vs: Volume (large amounts of data),
Velocity (speed of data processing), and Variety (different types of data).
9. In IT governance, COBIT primarily focuses on:
☑ A. Aligning IT processes with business objectives and managing risks
☐ B. Programming standards for software developers
☐ C. Designing database architectures
☐ D. Employee training programs
Rationale: COBIT (Control Objectives for Information and Related Technology) provides a
framework for IT governance, ensuring IT supports business goals and manages risks effectively.
10. Which scenario best exemplifies prescriptive analytics?
☐ A. Analyzing past sales to determine monthly revenue
☐ B. Creating dashboards for KPIs
☑ C. Recommending marketing strategies based on predicted customer responses
☐ D. Recording transactions in the ERP system
Rationale: Prescriptive analytics goes beyond predicting outcomes by recommending actions to
optimize results.
11. What is the primary purpose of master data management (MDM)?
☐ A. To store temporary transaction data
☑ B. To ensure consistency, accuracy, and accountability of key business data across systems
☐ C. To replace ETL processes
☐ D. To generate predictive models
Rationale: MDM establishes a single, trusted source of key business entities (like customers or
products) to reduce data redundancy and improve decision-making.
12. Which type of IT security control restricts access to systems based on user roles?
☐ A. Detective control
☑ B. Access control
, ☐ C. Corrective control
☐ D. Physical control
Rationale: Access control ensures that users can only access information and perform actions
allowed by their role, protecting sensitive data from unauthorized access.
13. Which methodology emphasizes iterative development, frequent collaboration, and
flexible responses to change?
☐ A. Waterfall
☑ B. Agile
☐ C. PRINCE2
☐ D. Six Sigma
Rationale: Agile is an iterative, incremental approach that prioritizes collaboration, flexibility,
and continuous delivery.
14. In supply chain management, which concept focuses on minimizing inventory while
meeting customer demand?
☐ A. Just-in-Case (JIC)
☑ B. Just-in-Time (JIT)
☐ C. Material Requirements Planning (MRP)
☐ D. Enterprise Resource Planning (ERP)
Rationale: JIT aims to reduce waste and holding costs by producing and delivering goods exactly
when needed.
15. Which of the following best describes a SaaS (Software as a Service) model?
☑ A. Software is hosted in the cloud and accessed via a web browser
☐ B. Software is installed on local machines and managed by internal IT staff
☐ C. Users purchase a perpetual license and maintain updates themselves
☐ D. Users receive source code to modify as needed
Rationale: SaaS delivers software over the internet, eliminating the need for local installation
and maintenance.
16. Which technique is used to evaluate risks by considering both likelihood and impact?
☐ A. SWOT analysis
