ACCA Strategic Professional · Advanced Performance Management · Technology and information systems
Zentrix Ltd's finance director wants a system that pulls data from the sales, production and HR systems into one central repository, structured for historical reporting and trend analysis by managers, rather than for processing day-to-day transactions. Which information system component best describes this requirement?
A data warehouse is the best fit because it consolidates data from several operational systems into one central repository organised for historical analysis and reporting, whereas a transaction processing system only captures daily transactions and is not designed for integrated trend analysis.
- AA data warehouseCorrect
- BA transaction processing system
- CA point-of-sale terminal network
- DA spreadsheet macro library
Explanation
A data warehouse integrates data from several operational sources and stores it in a structure optimised for querying, analysis and historical reporting. A transaction processing system records day-to-day events and is the source of data, not the integrated analytical store.
Did you get it right without looking?
One question tells you little. A timed set on Technology and information systems shows your real accuracy, how long you take and where you lose marks.
More Technology and information systems questions
- Brightmoor Bank holds customer data used in its balanced scorecard analytics. A phishing email lets an attacker obtain a finance analyst's c…
- Marlow Group uses an AI-driven robotic process automation tool to match supplier invoices to purchase orders and post routine entries. Which…
- Brightmoor Bank pays regional managers a bonus based on a customer satisfaction index drawn from an analytics platform. Internal audit finds…
- Brindle Telecom uses a machine-learning model on customer usage and billing data to estimate each customer's probability of cancelling withi…
- Zentra Retail plc wants its finance team to forecast monthly sales for each of its 400 stores using five years of historical sales, local we…
- Marlow Foods' management accountants currently produce monthly variance reports manually from exported spreadsheets, which are issued ten wo…