Here are 30 MCQ Questions with Answers from US CMA – Technology & Analytics / Internal Controls / Data & BI Topics.
1. Big Data is best characterized by which combination?
A. Volume, Value, Verification
C. Validity, Variance, Value
D. Volume, Visualization, Version
✅ Answer:
(Big Data = 3Vs: Volume, Velocity, Variety)
2. Data Mining primarily involves:
A. Storing historical data
B. Extracting useful patterns from large datasets
C. Deleting redundant data
D. Creating financial statements
✅ Answer:
3. A Data Warehouse is MOST appropriately described as:
A. Real-time transaction database
B. Department-specific database
C. Centralized repository of integrated historical data
D. Temporary data storage system
✅ Answer:
4. A Data Mart differs from a Data Warehouse because it:
A. Stores more data
B. Is department-focused
C. Is external to organization
D. Is used only for backup
✅ Answer:
5. Data Integration refers to:
A. Data deletion process
B. Combining data from multiple sources into unified view
C. Data encryption
D. Data compression
✅ Answer:
6. Which tool is MOST suitable for trend analysis over time?
A. Pie chart
B. Histogram
C. Line chart
D. Scatter plot
✅ Answer:
7. A Pie Chart is BEST used when:
A. Showing trends
B. Showing correlation
C. Showing proportion of categories
D. Showing distribution frequency
✅ Answer:
8. Histogram differs from Bar Chart because histogram:
A. Has gaps between bars
B. Represents continuous data
C. Shows percentages only
D. Is used only for time series
✅ Answer:
9. Heat Map is MOST useful to:
A. Display distribution of temperature only
B. Highlight intensity variations across dataset
C. Replace regression model
D. Calculate averages
✅ Answer:
10. Regression model is primarily used to:
A. Classify data
B. Predict dependent variable based on independent variable
C. Delete outliers
D. Segment customers
✅ Answer:
11. Cluster Sampling means:
A. Dividing population into homogeneous groups
B. Selecting every nth item
C. Dividing population into clusters and randomly selecting clusters
D. Selecting only high-value items
✅ Answer:
12. Stratified Sampling requires:
A. Random grouping
B. Homogeneous subgroups (strata) before sampling
C. Equal probability selection only
D. Selection based on judgment
✅ Answer:
13. Business Intelligence (BI) primarily helps management to:
A. Replace ERP
B. Make data-driven decisions
C. Encrypt databases
D. Eliminate internal controls
✅ Answer:
Example: Dashboard showing sales by region.
14. Machine Learning is BEST described as:
A. Manual programming of rules
B. Systems learning patterns from data without explicit programming
C. Spreadsheet automation
D. Data warehousing
✅ Answer:
Example: Fraud detection model.
15. Artificial Intelligence differs from Machine Learning because AI:
A. Is subset of ML
B. Includes broader goal of simulating human intelligence
C. Uses only regression
D. Does not use data
✅ Answer:
16. A Hot Site in disaster recovery is:
A. Empty office space
B. Fully equipped backup facility ready for immediate use
C. Backup taken weekly
D. Cloud storage only
✅ Answer:
17. Warm Site includes:
A. No equipment
B. Fully operational system
C. Basic infrastructure with partial configuration
D. Only paper documents
✅ Answer:
18. Cold Site is:
A. Fully operational
B. Basic infrastructure without equipment
C. Cloud-only backup
D. AI-based recovery
✅ Answer:
19. Disaster Recovery Plan (DRP) focuses on:
A. Long-term strategy
B. Restoring IT systems after disruption
C. Marketing continuity
D. Budget forecasting
✅ Answer:
20. Business Continuity Plan (BCP) is broader than DRP because it covers:
A. Only IT recovery
B. Entire business operations continuity
C. Only financial reporting
D. Only insurance claims
✅ Answer:
21. Which is an example of Data Visualization?
A. SQL Query
B. Dashboard with KPI charts
C. Data entry form
D. Backup log
✅ Answer:
22. In Big Data analytics, Velocity refers to:
A. Data accuracy
B. Speed of data generation and processing
C. Storage size
D. Data format
✅ Answer:
23. Which technique is MOST useful for fraud detection?
A. Regression
B. Machine Learning classification
C. Pie chart
D. Cluster sampling
✅ Answer:
24. Which of the following is NOT a benefit of Data Warehouse?
A. Improved reporting
B. Historical analysis
C. Real-time transaction processing
D. Integrated data
✅ Answer:
25. Stratified sampling is preferred over simple random sampling when:
A. Population is homogeneous
B. Population has distinct subgroups
C. Cost is zero
D. Data is continuous
✅ Answer:
26. A Scatter Plot is mainly used to:
A. Show proportions
B. Show frequency
C. Show relationship between two variables
D. Show categories
✅ Answer:
27. Data Mining technique used to group similar customers is:
A. Regression
B. Classification
C. Clustering
D. Sampling
✅ Answer:
28. Which of the following is MOST correct regarding Business Intelligence?
A. It predicts automatically without data
B. It transforms raw data into actionable insights
C. It replaces internal audit
D. It eliminates fraud risk
✅ Answer:
29. In Disaster Recovery, RTO (Recovery Time Objective) refers to:
A. Maximum acceptable downtime
B. Data accuracy
C. Backup frequency
D. Revenue target
✅ Answer:
30. Which visualization is MOST suitable for comparing categories?
A. Line Chart
B. Pie Chart
C. Bar Chart
D. Heat Map
✅ Answer:
Here are 30 Case-Based MCQs (Integrated, Analytical & Exam-Level) from US CMA – Data Analytics, BI, Big Data, DRP/BCP, Sampling & Visualization.
🔥 CASE-BASED MCQs
1.
A manufacturing company integrates sales, production, and customer complaint databases into a centralized system for historical trend analysis. However, operational systems slow down during peak hours.
Which is the MOST appropriate solution?
A. Replace ERP
B. Implement Data Mart
C. Implement Data Warehouse separate from OLTP
D. Use Pie Charts
✅ Answer:
2.
An auditor selects 5 branches randomly out of 60 and audits all transactions within selected branches.
This sampling method is:
A. Stratified
B. Cluster
C. Systematic
D. Judgmental
✅ Answer:
3.
A company divides customers into high, medium, and low revenue groups and randomly samples from each group proportionately.
This ensures:
A. Reduced bias through stratification
B. Elimination of sampling risk
C. Cluster-based efficiency
D. Big data integration
✅ Answer:
4.
An AI system detects unusual vendor payments by continuously learning from historical fraud cases without explicit reprogramming.
This is an example of:
A. Data Mining
B. Machine Learning
C. Business Intelligence
D. Data Integration
✅ Answer:
5.
During disaster recovery testing, management discovers IT systems can be restored in 8 hours, while business operations require restoration within 4 hours.
Which metric is violated?
A. RPO
B. RTO
C. SLA
D. KPI
✅ Answer:
6.
A company maintains infrastructure but must install software and restore backups after disaster. Recovery time: 3–4 days.
Type of site?
A. Hot
B. Cold
C. Warm
D. Mirror
✅ Answer:
7.
A dashboard displays monthly sales trends over 5 years to detect seasonality.
Best visualization?
A. Pie Chart
B. Histogram
C. Line Chart
D. Heat Map
✅ Answer:
8.
Management wants to examine correlation between advertising expense and sales revenue.
Best analytical tool?
A. Bar Chart
B. Regression Model
C. Pie Chart
D. Cluster Sampling
✅ Answer:
9.
An organization stores terabytes of social media feedback generated every second.
Primary Big Data challenge here is:
A. Variety
B. Velocity
C. Volume
D. Validity
✅ Answer:
10.
An auditor uses analytics to identify duplicate payments by searching identical invoice numbers.
This is:
A. Predictive analytics
B. Descriptive analytics
C. Data mining rule detection
D. Regression
✅ Answer:
11.
A histogram shows frequency of machine downtime hours. Bars touch each other.
Why?
A. It represents categorical data
B. Continuous data intervals
C. Stratified data
D. Percentage breakdown
✅ Answer:
12.
Management wants a visual showing profitability by region as color intensity on a map.
Best option?
A. Line chart
B. Heat map
C. Pie chart
D. Scatter plot
✅ Answer:
13.
Data from multiple subsidiaries use different currency formats. Before loading into warehouse, company standardizes format.
This step is:
A. Data mining
B. Data cleansing/integration
C. AI modeling
D. BI reporting
✅ Answer:
14.
A predictive fraud model incorrectly flags many legitimate transactions as fraud.
This indicates high:
A. Type II error
B. False positives
C. Regression bias
D. Sampling frame error
✅ Answer:
15.
Which scenario BEST distinguishes BI from AI?
A. Dashboard showing KPI vs AI chatbot resolving customer queries
B. Data warehouse vs data mart
C. Pie chart vs histogram
D. Sampling vs clustering
✅ Answer:
16.
A company uses clustering to segment customers based on buying patterns.
Primary objective?
A. Predict sales precisely
B. Group similar observations
C. Test hypothesis
D. Eliminate fraud
✅ Answer:
17.
A cold site is selected to reduce cost. Which is the BIGGEST risk?
A. Data redundancy
B. Long recovery time
C. Data duplication
D. Overfitting
✅ Answer:
18.
If RPO is 2 hours, organization must:
A. Restore system in 2 hours
B. Ensure no more than 2 hours of data loss
C. Resume operations in 2 hours
D. Backup every 24 hours
✅ Answer:
19.
A regression output shows R² = 0.85.
This implies:
A. 85% of dependent variable variance explained by model
B. 85% prediction accuracy
C. 85% sampling reliability
D. 85% fraud probability
✅ Answer:
20.
A company wants department-level reporting instead of enterprise-wide analysis.
Best solution?
A. Data Warehouse
B. Data Mart
C. Big Data Lake
D. AI Engine
✅ Answer:
21.
Which visualization is LEAST appropriate for showing trend over time?
A. Line chart
B. Scatter plot with time axis
C. Pie chart
D. Area chart
✅ Answer:
22.
An ML credit model improves accuracy after processing more historical data.
This reflects:
A. Data integration
B. Self-learning capability
C. Regression assumption
D. Sampling adjustment
✅ Answer:
23.
Auditor divides 10,000 invoices into groups by region and selects proportionately.
Sampling advantage?
A. Reduced variance
B. Faster processing
C. Eliminates bias
D. No sampling risk
✅ Answer:
24.
A DRP focuses primarily on:
A. Maintaining competitive advantage
B. Restoring IT systems
C. Revenue growth
D. Data mining
✅ Answer:
25.
Which scenario BEST illustrates AI?
A. Static dashboard
B. Spreadsheet formula
C. Voice-based virtual assistant resolving queries
D. SQL report
✅ Answer:
26.
Data warehouse differs from OLTP because it is:
A. Optimized for transactions
B. Normalized
C. Optimized for analysis & queries
D. Real-time processing
✅ Answer:
27.
Heat map detecting high-risk vendors is example of:
A. Data visualization aiding risk assessment
B. Machine learning
C. Cluster sampling
D. Regression
✅ Answer:
28.
A company uses systematic sampling selecting every 50th invoice. Major risk?
A. Pattern bias
B. High cost
C. Overfitting
D. Data cleansing issue
✅ Answer:
29.
If business operations continue but IT systems fail, which plan activates first?
A. BCP
B. DRP
C. AI response
D. Data warehouse
✅ Answer:
30.
Which situation MOST likely requires predictive analytics?
A. Reporting last year’s sales
B. Explaining why sales declined
C. Forecasting next quarter demand
D. Summarizing revenue by region
✅ Answer:
. Here are 20 Integrated Multi-Layer Caselets combining
Governance + IT Controls + Data Analytics + DRP + BCP + Sampling + AI/BI
(US CMA Exam Level – Highly Analytical & Integrated)
Each case has 1 MCQ with 4 options.
🔥 INTEGRATED MULTI-LAYER CASELETS
Caselet 1 – Data Warehouse Governance Failure
ABC Ltd. implemented a centralized data warehouse. Internal audit found inconsistent revenue data across dashboards because regional systems use different revenue recognition rules. Board audit committee is concerned about reporting integrity.
What should management implement FIRST?
A. Machine learning fraud model
B. Strong data governance framework & standardized data definitions
C. Cold site backup
D. Cluster sampling
✅ Answer:
Caselet 2 – Disaster Recovery vs Business Continuity
A flood shuts down the company’s primary data center. IT systems are restored in 6 hours at a hot site, but customer service operations resume only after 3 days.
Which statement is MOST correct?
A. DRP failed
B. BCP failed
C. Both DRP and BCP failed
D. Sampling risk caused delay
✅ Answer:
(DRP = IT restored. BCP = operations continuity failed.)
Caselet 3 – Fraud Analytics & False Positives
An AI-based fraud detection system flags 30% of legitimate transactions as suspicious. Finance team complains about operational disruption.
Primary issue?
A. Overfitting
B. High false positive rate
C. Sampling bias
D. Weak governance
✅ Answer:
Caselet 4 – IT General Controls Weakness
During audit, it was noted that developers have direct access to production systems. Simultaneously, the company uses BI dashboards for strategic decisions.
Biggest risk?
A. Visualization risk
B. Segregation of duties violation
C. Data warehouse failure
D. Cold site inadequacy
✅ Answer:
Caselet 5 – Sampling Strategy in Audit Analytics
Internal audit divides procurement transactions by vendor size and samples proportionately.
Why is this MOST appropriate?
A. Eliminates audit risk
B. Ensures representation across risk categories
C. Reduces big data velocity
D. Improves regression accuracy
✅ Answer:
(Stratified sampling for risk-based audit.)
Caselet 6 – Data Integration Risk
ERP, CRM, and HR systems feed into warehouse. HR data includes outdated employee IDs causing duplication.
Primary control missing?
A. AI monitoring
B. Data cleansing & validation controls
C. DRP testing
D. Regression analysis
✅ Answer:
Caselet 7 – Heat Map & Governance Oversight
Board reviews heat map showing high-risk vendor concentration in one region.
Best governance response?
A. Ignore visualization
B. Initiate targeted internal audit review
C. Replace warehouse
D. Implement cold site
✅ Answer:
Caselet 8 – RPO & Financial Risk
Company’s RPO is 12 hours. Cyberattack results in 18 hours of lost accounting data.
Implication?
A. RTO failure
B. Governance control failure over backup frequency
C. BI system weakness
D. Sampling error
✅ Answer:
Caselet 9 – Predictive Analytics in Budgeting
Management uses regression model to forecast sales but ignores macroeconomic variables, leading to inaccurate budgets.
Root cause?
A. Data warehouse failure
B. Omitted variable bias
C. DRP weakness
D. AI malfunction
✅ Answer:
Caselet 10 – Cluster Sampling Risk
Audit selects 4 warehouses randomly and audits all transactions inside them. One high-risk warehouse was not selected.
Main limitation?
A. Lack of stratification
B. Data mining failure
C. BI deficiency
D. Heat map misuse
✅ Answer:
Caselet 11 – Big Data & Velocity Issue
Real-time IoT production sensors generate massive streaming data. System crashes during peak load.
Big Data challenge MOST evident?
A. Variety
B. Volume
C. Velocity
D. Validity
✅ Answer:
Caselet 12 – Governance & AI Ethics
AI credit approval model disproportionately rejects applicants from certain regions.
Board concern relates to:
A. DRP
B. Bias & ethical governance
C. Data mart issue
D. Cluster sampling
✅ Answer:
Caselet 13 – Hot Site Cost vs Risk
CFO wants to downgrade hot site to cold site to reduce cost. Risk committee disagrees.
Strongest argument for hot site?
A. Lower sampling error
B. Faster recovery minimizing financial & reputational loss
C. Better regression output
D. Data visualization improvement
✅ Answer:
Caselet 14 – Business Intelligence Limitation
Dashboard shows declining profit margin but not underlying cause.
This illustrates limitation of:
A. Predictive analytics
B. Descriptive analytics
C. Cluster analysis
D. DRP
✅ Answer:
Caselet 15 – Data Mart Misuse
Marketing creates independent data mart separate from finance warehouse. Revenue figures differ in board report.
Primary governance weakness?
A. Lack of centralized data governance
B. AI failure
C. RPO mismatch
D. Sampling bias
✅ Answer:
Caselet 16 – DRP Testing Failure
Company never tested DRP. During ransomware attack, backup restoration fails.
Best control improvement?
A. Implement regression
B. Conduct periodic DRP simulation testing
C. Introduce BI dashboard
D. Stratified sampling
✅ Answer:
Caselet 17 – Histogram Interpretation Error
Operations manager interprets histogram of defect rates as categorical comparison.
Mistake because histogram represents:
A. Categorical groups
B. Continuous distribution
C. Proportions
D. Time trends
✅ Answer:
Caselet 18 – Regression & Governance
Regression predicts 90% accuracy historically but fails during economic crisis.
Primary lesson?
A. AI is superior
B. Models require periodic recalibration & governance oversight
C. Heat maps are better
D. Sampling removes macro risk
✅ Answer:
Caselet 19 – Business Continuity Planning Gap
Company restored IT systems but supply chain partners were not aligned with continuity plan.
BCP gap relates to:
A. Internal controls only
B. External stakeholder integration
C. Regression accuracy
D. AI bias
✅ Answer:
Caselet 20 – Integrated Risk Scenario
Company uses:
• AI fraud detection
• Data warehouse for reporting
• Hot site backup
However, no board oversight over data governance policies.
Most significant enterprise risk?
A. Technical failure
B. Governance & oversight deficiency
C. Sampling risk
D. Visualization bias
✅ Answer:
🔥 What This Tests in CMA Exam
These caselets integrate:
• Corporate Governance
• IT General Controls
• Data Governance
• AI / BI distinction
• Sampling methods
• Regression interpretation
• DRP vs BCP
• Big Data 3Vs
• Visualization interpretation
www.gmsisuccess.in
No comments:
Post a Comment