US CMA Part 1 · Chapter 6
Technology and Analytics MCQs with Answers
22 multiple-choice questions on Technology and Analytics for US CMA Part 1 Financial Planning, Performance and Analytics. Try each one before revealing the answer and explanation.
Practise this chapter interactivelyQuestion 1
A regression of monthly utility cost on machine hours has a coefficient of determination (R-squared) of 0.81. What does this indicate?
- A) Utility cost increases by $0.81 for each additional machine hour
- B) There is an 81% probability that the regression equation is correct
- C) 81% of the variation in utility cost is explained by variation in machine hours
- D) The correlation coefficient between the variables is 0.81
Show answer & explanation
Answer: C) 81% of the variation in utility cost is explained by variation in machine hours
R-squared measures the proportion of the variation in the dependent variable explained by the independent variable. It is not the slope, not a probability, and the correlation coefficient would be the square root, 0.9 (if the relationship is positive).
Question 2
What is the defining characteristic of an enterprise resource planning (ERP) system?
- A) It is a stand-alone general ledger package used only by the accounting department
- B) It is a spreadsheet model used for one-off capital budgeting decisions
- C) It integrates business processes such as finance, purchasing, production and sales around a single shared database
- D) It replaces the need for internal controls over transaction processing
Show answer & explanation
Answer: C) It integrates business processes such as finance, purchasing, production and sales around a single shared database
An ERP system links the main functional areas of a business through a common database, so data entered once is available across the organization. This reduces duplication and inconsistency, but ERP systems still require strong internal controls.
Question 3
Which activity belongs to the expenditure (purchase-to-pay) cycle rather than the revenue cycle?
- A) Checking customer credit before approving a sales order
- B) Receiving goods from suppliers and matching receiving reports to purchase orders
- C) Shipping goods to customers
- D) Recording customer remittances
Show answer & explanation
Answer: B) Receiving goods from suppliers and matching receiving reports to purchase orders
The expenditure cycle covers requisitioning, purchasing, receiving, approving supplier invoices and paying suppliers. Credit approval, shipping and recording customer receipts are all part of the revenue (order-to-cash) cycle.
Question 4
What is the main purpose of enterprise performance management (EPM) software?
- A) To support planning, budgeting, forecasting, consolidation and performance reporting across the organization
- B) To process day-to-day sales and purchase transactions
- C) To manage network security and user passwords
- D) To replace the external audit of financial statements
Show answer & explanation
Answer: A) To support planning, budgeting, forecasting, consolidation and performance reporting across the organization
EPM (also called corporate performance management) systems sit on top of transactional systems and help management plan, budget, forecast, consolidate results, model scenarios and monitor performance against strategy.
Question 5
In the systems development life cycle (SDLC), during which phase are user requirements gathered and the current system studied in detail?
- A) Systems implementation
- B) Systems maintenance
- C) Post-implementation review
- D) Systems analysis
Show answer & explanation
Answer: D) Systems analysis
In the systems analysis phase, analysts study the existing system and define user requirements for the new one. Design follows, then development and testing, implementation (including conversion and training), and ongoing operation and maintenance.
Question 6
Which task is the best candidate for robotic process automation (RPA)?
- A) Deciding whether to enter a new geographic market
- B) Copying data from standardized supplier invoices into the payables system using fixed rules
- C) Negotiating a new labor agreement with a union
- D) Assessing the reasonableness of management's goodwill impairment judgments
Show answer & explanation
Answer: B) Copying data from standardized supplier invoices into the payables system using fixed rules
RPA software bots mimic human actions in repetitive, high-volume, rule-based tasks with structured digital inputs. Strategic decisions, negotiations and complex judgments require human reasoning and are not suitable for RPA.
Question 7
A company subscribes to a web-based accounting application that the provider hosts, maintains and upgrades; users simply log in through a browser. Which cloud service model is this?
- A) Infrastructure as a service (IaaS)
- B) Platform as a service (PaaS)
- C) Software as a service (SaaS)
- D) On-premises licensed software
Show answer & explanation
Answer: C) Software as a service (SaaS)
With SaaS, the provider delivers a complete application over the internet and manages the underlying infrastructure and software. IaaS provides only computing resources such as servers and storage, and PaaS provides a platform on which customers build and run their own applications.
Question 8
Which feature of blockchain technology is most relevant to the reliability of accounting records?
- A) A single central administrator can edit any past transaction at will
- B) Transactions are recorded on a distributed ledger, and once validated, blocks are extremely difficult to alter without detection
- C) Transactions are stored only on the company's own server
- D) Blockchain eliminates the need to verify the existence of the underlying assets
Show answer & explanation
Answer: B) Transactions are recorded on a distributed ledger, and once validated, blocks are extremely difficult to alter without detection
Blockchain maintains a shared, distributed ledger in which each block is cryptographically linked to the previous one, making recorded transactions effectively immutable. However, it does not guarantee that the underlying transaction was valid or that the assets exist.
Question 9
An employee receives an email that appears to come from the company's bank, asking her to click a link and confirm her login credentials. This is an example of:
- A) A denial-of-service attack
- B) Data mining
- C) A brute-force password attack
- D) Phishing
Show answer & explanation
Answer: D) Phishing
Phishing uses fraudulent messages that impersonate trusted organizations to trick users into revealing credentials or other sensitive information. A denial-of-service attack floods a system with traffic, and brute-force attacks try many passwords.
Question 10
Malicious software encrypts a company's files and the attackers demand payment in cryptocurrency for the decryption key. Which control is most important in limiting the damage from this type of attack?
- A) Regular, tested backups stored separately from the production network
- B) Increasing the internet bandwidth available to the company
- C) Moving all files to employees' personal laptops
- D) Disabling the company's firewall to speed up recovery
Show answer & explanation
Answer: A) Regular, tested backups stored separately from the production network
This is a ransomware attack. Secure, isolated and regularly tested backups allow the company to restore its data without paying the ransom. Prevention also relies on patching, user training and endpoint protection.
Question 11
Within a data governance program, who is typically responsible for defining and maintaining the quality, definitions and appropriate use of a particular set of business data?
- A) The external auditor
- B) A data steward
- C) The network administrator
- D) Every user who enters data
Show answer & explanation
Answer: B) A data steward
Data stewards are accountable for specific data domains: they set definitions and quality standards, resolve data issues and ensure the data is used appropriately. Data governance assigns these responsibilities formally, alongside policies covering the data life cycle from capture to purging.
Question 12
In the context of big data, the characteristic 'velocity' refers to:
- A) The sheer amount of data stored
- B) The speed at which data is generated and must be processed
- C) The variety of formats in which data arrives
- D) The accuracy and trustworthiness of the data
Show answer & explanation
Answer: B) The speed at which data is generated and must be processed
The common Vs of big data are volume (amount), velocity (speed of generation and processing), variety (structured, semi-structured and unstructured formats) and veracity (reliability).
Question 13
Which type of analytics recommends a course of action, for example by optimizing the delivery schedule that minimizes cost?
- A) Prescriptive analytics
- B) Descriptive analytics
- C) Diagnostic analytics
- D) Predictive analytics
Show answer & explanation
Answer: A) Prescriptive analytics
Descriptive analytics reports what happened, diagnostic analytics explains why, predictive analytics forecasts what is likely to happen, and prescriptive analytics recommends what should be done, often using optimization or simulation.
Question 14
An analyst drills down into sales data to determine why revenue in the western region fell last quarter. This is an example of:
- A) Diagnostic analytics
- B) Prescriptive analytics
- C) Predictive analytics
- D) Descriptive analytics only
Show answer & explanation
Answer: A) Diagnostic analytics
Diagnostic analytics investigates the causes of past outcomes, using techniques such as drill-down, data discovery and correlation analysis. Simply reporting that revenue fell would be descriptive analytics.
Question 15
Which of the following is the best example of unstructured data?
- A) A table of invoice numbers, dates and amounts
- B) General ledger account balances
- C) Text of customer reviews posted on social media
- D) A list of employee IDs and pay rates
Show answer & explanation
Answer: C) Text of customer reviews posted on social media
Unstructured data does not fit a predefined data model or row-and-column format; examples include free text, emails, images and video. Invoice tables, ledger balances and payroll lists are structured data.
Question 16
For a regression model, the total sum of squares is 50,000 and the sum of squared errors (residual sum of squares) is 8,000. What is the coefficient of determination?
- A) 0.84
- B) 0.16
- C) 0.92
- D) 0.86
Show answer & explanation
Answer: A) 0.84
R-squared = 1 - SSE / SST = 1 - 8,000 / 50,000 = 1 - 0.16 = 0.84. So 84% of the variation in the dependent variable is explained by the model. 0.16 is the unexplained proportion, and 0.92 would be the correlation coefficient.
Question 17
In a regression of delivery cost on miles driven, the slope coefficient is 3.6 and its standard error is 1.2. Using the common rule of thumb, what can be concluded?
- A) The t-statistic is 0.33, so miles driven is not statistically significant
- B) The t-statistic is 4.32, so miles driven explains 43% of delivery cost
- C) The t-statistic is 3.0, which exceeds 2, so miles driven is a statistically significant explanatory variable
- D) The t-statistic is 2.4, so the intercept should be removed from the model
Show answer & explanation
Answer: C) The t-statistic is 3.0, which exceeds 2, so miles driven is a statistically significant explanatory variable
The t-statistic = coefficient / standard error = 3.6 / 1.2 = 3.0. A t-value greater than about 2 indicates that the coefficient is significantly different from zero at roughly the 95% confidence level, so the independent variable has explanatory power.
Question 18
A cost estimation equation was derived from data on production between 2,000 and 6,000 units per month. Why should managers be cautious about using it to predict costs at 12,000 units?
- A) Regression equations can only be used for historical data, never for forecasts
- B) The intercept automatically becomes negative above the observed range
- C) The prediction lies outside the relevant range, where the cost relationship may not hold
- D) R-squared always falls to zero outside the observed data
Show answer & explanation
Answer: C) The prediction lies outside the relevant range, where the cost relationship may not hold
Regression results are reliable only within the relevant range of the data used to estimate them. Extrapolating far beyond that range is risky because fixed costs may step up and variable cost rates may change, for example through overtime or capacity constraints.
Question 19
What distinguishes Monte Carlo simulation from simple sensitivity analysis?
- A) It changes one input at a time while holding all others constant
- B) It repeatedly draws random values for several uncertain inputs from probability distributions to produce a distribution of possible outcomes
- C) It uses only the single most likely value for each input
- D) It finds the line of best fit between two variables
Show answer & explanation
Answer: B) It repeatedly draws random values for several uncertain inputs from probability distributions to produce a distribution of possible outcomes
Monte Carlo simulation runs many trials, each using randomly generated values for the uncertain variables based on their probability distributions. The result is a range of outcomes with associated probabilities, rather than a single point estimate.
Question 20
An analyst wants to show whether there is a relationship between monthly advertising spend and monthly sales revenue across 36 months. Which visualization is most appropriate?
- A) A pie chart
- B) A stacked bar chart of sales by product
- C) A single gauge (dial) chart
- D) A scatter plot
Show answer & explanation
Answer: D) A scatter plot
A scatter plot shows each observation as a point plotted against two variables, making correlation, clusters and outliers easy to see. Pie charts show composition of a whole, and gauges display a single measure against a target.
Question 21
A retailer wants to group its customers into segments based on purchasing behavior, without any predefined labels for the groups. Which data mining technique is most suitable?
- A) Clustering
- B) Linear regression
- C) Classification using a labeled training set
- D) Time-series smoothing
Show answer & explanation
Answer: A) Clustering
Clustering is an unsupervised learning technique that groups observations by similarity without predefined categories. Classification is supervised and requires labeled examples, and regression predicts a continuous outcome.
Question 22
A company uses exponential smoothing with a smoothing constant (alpha) of 0.3. The forecast for May was 500 units and actual May demand was 540 units. What is the forecast for June?
- A) 528 units
- B) 520 units
- C) 162 units
- D) 512 units
Show answer & explanation
Answer: D) 512 units
New forecast = previous forecast + alpha x (actual - previous forecast) = 500 + 0.3 x (540 - 500) = 500 + 12 = 512 units. Equivalently, 0.3 x 540 + 0.7 x 500.