Section A
Here are 50 MCQ Questions on Technology and Data Analytics (useful for CIA, CMA, Internal Audit, and Business Analytics exams).
MCQs on Technology & Data Analytics
1.
Which technology is primarily used to analyze large volumes of structured and unstructured data?
A. Data warehousing
B. Big Data analytics
C. Word processing
D. Spreadsheet formatting
Answer:
2.
Which analytics type answers the question “What happened?”
A. Predictive analytics
B. Diagnostic analytics
C. Descriptive analytics
D. Prescriptive analytics
Answer:
3.
Which analytics type predicts future trends and outcomes?
A. Descriptive analytics
B. Predictive analytics
C. Diagnostic analytics
D. Prescriptive analytics
Answer:
4.
Which analytics method recommends best possible action or decision?
A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Prescriptive analytics
Answer:
5.
Which of the following tools is widely used for data analysis by auditors?
A. Spreadsheet software
B. Word processor
C. Presentation software
D. Email software
Answer:
6.
Which technique identifies hidden patterns in large datasets?
A. Data mining
B. Data formatting
C. Data replication
D. Data encryption
Answer:
7.
Which database structure organizes data into tables with rows and columns?
A. Relational database
B. Hierarchical database
C. Network database
D. Distributed database
Answer:
8.
Which technology enables real-time processing and analysis of large data streams?
A. Cloud computing
B. Batch processing
C. Stream processing
D. Manual processing
Answer:
9.
Which of the following is an example of structured data?
A. Images
B. Videos
C. Database tables
D. Social media posts
Answer:
10.
Which of the following is unstructured data?
A. Customer database
B. Financial ledger
C. Emails and images
D. Inventory list
Answer:
11.
Which term refers to the process of cleaning incorrect or inconsistent data?
A. Data validation
B. Data cleansing
C. Data mining
D. Data storage
Answer:
12.
Which analytics technique groups similar data points together?
A. Regression
B. Clustering
C. Classification
D. Forecasting
Answer:
13.
Which analytics technique assigns data to predefined categories?
A. Clustering
B. Classification
C. Forecasting
D. Sorting
Answer:
14.
Which technology allows remote storage and access of data via the internet?
A. Cloud computing
B. Local storage
C. Manual system
D. Standalone server
Answer:
15.
Which data analytics tool is widely used for interactive data visualization?
A. Tableau
B. MS Word
C. Notepad
D. Email
Answer:
16.
Which of the following describes Big Data?
A. Small datasets
B. Extremely large and complex datasets
C. Manual records
D. Paper documents
Answer:
17.
Which of the following is one of the 3 Vs of Big Data?
A. Value
B. Variety
C. Verification
D. Validity
Answer:
18.
The 3 Vs of Big Data include:
A. Value, Validity, Vision
B. Volume, Velocity, Variety
C. Vision, Volume, Value
D. Verification, Value, Variety
Answer:
19.
Which tool is commonly used for querying relational databases?
A. SQL
B. HTML
C. Java
D. Python
Answer:
20.
Which programming language is widely used for data analytics and machine learning?
A. Python
B. HTML
C. CSS
D. XML
Answer:
21.
Which term refers to visual representation of data?
A. Data modeling
B. Data visualization
C. Data mining
D. Data encryption
Answer:
22.
Which graph is commonly used to show trends over time?
A. Pie chart
B. Line chart
C. Histogram
D. Scatter plot
Answer:
23.
Which analytics technique examines relationships between variables?
A. Regression analysis
B. Sorting
C. Clustering
D. Classification
Answer:
24.
Which technology uses algorithms to allow systems to learn from data?
A. Artificial Intelligence
B. Machine Learning
C. Blockchain
D. Data storage
Answer:
25.
Which technology provides secure and decentralized transaction records?
A. Blockchain
B. Cloud computing
C. Data warehouse
D. Spreadsheet
Answer:
26.
Which data storage system is designed for querying and analyzing large datasets?
A. Data warehouse
B. Data entry system
C. Word processor
D. Operating system
Answer:
27.
Which process moves data from multiple sources into a data warehouse?
A. ETL
B. FTP
C. HTTP
D. SQL
Answer:
28.
ETL stands for:
A. Extract, Transform, Load
B. Enter, Transfer, Link
C. Evaluate, Transfer, Load
D. Extract, Test, Link
Answer:
29.
Which technique identifies abnormal or suspicious transactions?
A. Forecasting
B. Anomaly detection
C. Sorting
D. Filtering
Answer:
30.
Which analytics approach helps detect fraud patterns?
A. Data mining
B. Formatting
C. Encoding
D. Storage
Answer:
31.
Which technology allows automation of repetitive processes using software bots?
A. Artificial Intelligence
B. Robotic Process Automation (RPA)
C. Blockchain
D. Cloud storage
Answer:
32.
Which of the following helps secure sensitive data?
A. Encryption
B. Formatting
C. Sorting
D. Classification
Answer:
33.
Which technology enables computers to understand human language?
A. Machine Learning
B. Natural Language Processing
C. Blockchain
D. Cloud computing
Answer:
34.
Which technique identifies relationships among items frequently purchased together?
A. Association analysis
B. Clustering
C. Regression
D. Forecasting
Answer:
35.
Which type of chart shows proportion of categories?
A. Pie chart
B. Line chart
C. Histogram
D. Scatter plot
Answer:
36.
Which technology allows scalable computing resources on demand?
A. Cloud computing
B. Manual system
C. Batch processing
D. Standalone computing
Answer:
37.
Which term refers to automated decision-making using algorithms?
A. Artificial Intelligence
B. Spreadsheet analysis
C. Data formatting
D. Manual processing
Answer:
38.
Which analytics technique predicts future sales based on historical data?
A. Forecasting
B. Sorting
C. Classification
D. Clustering
Answer:
39.
Which database query retrieves specific data from a database?
A. SELECT
B. INSERT
C. DELETE
D. UPDATE
Answer:
40.
Which term describes combining data from different sources for analysis?
A. Data integration
B. Data deletion
C. Data encryption
D. Data compression
Answer:
41.
Which technology enables real-time dashboards and reports?
A. Business Intelligence (BI) tools
B. Word processing
C. Text editors
D. Email software
Answer:
42.
Which analytics tool is widely used in business intelligence reporting?
A. Power BI
B. Notepad
C. Paint
D. Calculator
Answer:
43.
Which concept ensures accuracy and reliability of data?
A. Data integrity
B. Data storage
C. Data replication
D. Data formatting
Answer:
44.
Which system stores current operational data?
A. Transaction processing system
B. Data warehouse
C. Data lake
D. Spreadsheet
Answer:
45.
Which term refers to raw data stored in its original format?
A. Data lake
B. Data warehouse
C. Database table
D. Spreadsheet
Answer:
46.
Which algorithm is commonly used for classification problems?
A. Decision Tree
B. Sorting
C. Filtering
D. Compression
Answer:
47.
Which analytics method determines root cause of a problem?
A. Diagnostic analytics
B. Predictive analytics
C. Descriptive analytics
D. Prescriptive analytics
Answer:
48.
Which technique visually shows relationship between two variables?
A. Scatter plot
B. Pie chart
C. Histogram
D. Bar chart
Answer:
49.
Which term refers to automated analysis of large datasets using algorithms?
A. Machine learning
B. Word processing
C. Data formatting
D. Manual analysis
Answer:
50.
Which technology integrates analytics, reporting, and dashboards for decision making?
A. Business Intelligence
B. Database storage
C. Operating system
D. Word processing
Answer:
www.gmsisuccess.in
Section B...
Here are Case-Based Questions on Technology and Data Analytics (useful for CIA, CMA, Internal Audit, and Professional Accounting exams).
Case-Based Questions on Technology & Data Analytics
Case 1: Fraud Detection Using Data Analytics
An internal auditor used data analytics software to review all purchase transactions for the year. The analysis identified several transactions where the same vendor invoice number appeared multiple times, resulting in duplicate payments.
What analytics technique helped identify this issue?
A. Forecasting
B. Duplicate transaction testing
C. Regression analysis
D. Classification analysis
Answer:
Case 2: Identifying Unusual Transactions
An auditor analyzed employee expense reimbursement data and discovered that one employee submitted claims significantly higher than other employees in similar positions.
Which data analytics method is most useful in identifying this issue?
A. Anomaly detection
B. Data encryption
C. Data compression
D. Data storage
Answer:
Case 3: Predicting Customer Behavior
A company uses historical sales data and statistical models to predict future product demand.
Which type of analytics is being used?
A. Descriptive analytics
B. Predictive analytics
C. Diagnostic analytics
D. Prescriptive analytics
Answer:
Case 4: Data Visualization
A management team uses interactive dashboards to monitor key performance indicators (KPIs) such as sales growth, inventory turnover, and customer satisfaction.
Which technology is primarily used?
A. Business Intelligence tools
B. Database encryption
C. Operating system software
D. Word processing software
Answer:
Case 5: Data Integrity Issue
During data analysis, an auditor noticed that some customer records had missing email addresses and incorrect phone number formats.
Which process should be performed first before analysis?
A. Data cleansing
B. Data mining
C. Data encryption
D. Data storage
Answer:
Case 6: Big Data Environment
A retail company collects millions of daily transactions from online and offline stores and analyzes them to understand customer buying patterns.
Which concept best describes this data environment?
A. Big Data analytics
B. Batch processing
C. Manual processing
D. Traditional accounting system
Answer:
Case 7: Fraud Pattern Detection
An auditor used data mining techniques and found that multiple vendors shared the same bank account number.
What risk does this situation most likely indicate?
A. Duplicate payments
B. Potential vendor fraud
C. Data entry error
D. Network failure
Answer:
Case 8: Data Warehouse Use
A company stores historical financial data from multiple departments in a centralized database to support management reporting and analysis.
This system is known as:
A. Data warehouse
B. Transaction processing system
C. Spreadsheet database
D. Operating system
Answer:
Case 9: Automated Processes
An organization uses software robots to automatically process invoices, extract data, and update accounting records.
Which technology is being used?
A. Artificial Intelligence
B. Robotic Process Automation (RPA)
C. Data encryption
D. Data mining
Answer:
Case 10: Root Cause Analysis
A company noticed declining sales and used data analytics to determine why sales dropped in certain regions.
Which type of analytics is being used?
A. Descriptive analytics
B. Predictive analytics
C. Diagnostic analytics
D. Prescriptive analytics
Answer:
Case 11: Customer Segmentation
A marketing team groups customers into segments based on purchase behavior and demographics.
Which analytics technique is used?
A. Clustering
B. Forecasting
C. Regression
D. Sorting
Answer:
Case 12: Decision Recommendation
A company uses analytics to recommend optimal pricing strategies based on demand and competitor prices.
Which analytics type is applied?
A. Descriptive analytics
B. Predictive analytics
C. Diagnostic analytics
D. Prescriptive analytics
Answer:
Case 13: Real-Time Data Monitoring
An organization monitors online sales transactions in real time to detect fraud immediately.
Which technology enables this?
A. Batch processing
B. Stream processing
C. Manual analysis
D. Spreadsheet analysis
Answer:
Case 14: Data Integration
A company collects data from CRM systems, ERP systems, and sales databases and integrates them into one analytical platform.
Which process supports this integration?
A. ETL process
B. Data encryption
C. Data replication
D. Data compression
Answer:
Case 15: Relationship Analysis
An auditor analyzes data to determine whether marketing expenditure influences sales revenue.
Which analytical technique should be used?
A. Regression analysis
B. Clustering
C. Sorting
D. Classification
Answer:
www.gmsisuccess.in