CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Data Analytics
Which statement correctly distinguishes a data warehouse used for analytics from an operational transaction database?
A data warehouse stores integrated historical data from many sources and is optimised for querying, reporting and analysis, whereas an operational database is tuned to process day-to-day transactions quickly. The option that reverses these roles is wrong, since recording individual sales as they occur is the operational system's job.
- AA data warehouse stores integrated historical data optimised for querying and analysis, while the operational database handles day-to-day transactionsCorrect
- BA data warehouse is optimised for recording each sale as it happens, while the operational database holds historical summaries
- CBoth store only current data and differ only in vendor
- DA data warehouse cannot be used for reporting or dashboards
Explanation
A data warehouse integrates data from several sources and keeps history for analysis and reporting. Operational (OLTP) databases are tuned for fast routine transactions. The second option reverses these roles.
Did you get it right without looking?
One question tells you little. A timed set on Data Analytics shows your real accuracy, how long you take and where you lose marks.
More Data Analytics questions
- An Indian e-commerce company collects customer data in the form of images of products returned, free-text reviews, and a table of orders wit…
- Kaveri Textiles Ltd. analyses customer purchase data and finds that two unrelated variables, ice-cream sales and its dealer complaints, rise…
- An e-commerce firm applies predictive analytics to customer browsing and purchase data, creating individual profiles to target advertisement…
- A Mumbai-based fintech firm stores customer KYC details in a relational table with fixed columns such as name, PAN and date of birth. How is…
- A private bank in Pune applies analytics to customer transaction data and finds a cluster of accounts with many small deposits just under a …
- A Mumbai-based retailer begins an analytics project by first stating that it wants to reduce customer churn in its loyalty programme and def…