GSLC · Question #378
Which of the following applications would be considered a data warehousing application?
The correct answer is C. Fraud detection. Fraud detection is a classic data warehousing application because it requires analyzing large volumes of historical transaction data to identify patterns and anomalies across time.
Question
Which of the following applications would be considered a data warehousing application?
Options
- AGolf score tracking
- BBadge reader
- CFraud detection
- DeCommerce site
How the community answered
(51 responses)- A4% (2)
- B2% (1)
- C92% (47)
- D2% (1)
Why each option
Fraud detection is a classic data warehousing application because it requires analyzing large volumes of historical transaction data to identify patterns and anomalies across time.
Golf score tracking is a simple transactional (OLTP) application that stores and retrieves individual records, not a large-scale analytical workload.
A badge reader is an access control system that performs real-time transactional lookups, not analytical processing over historical data sets.
Data warehousing applications are characterized by processing and analyzing large aggregated datasets to support business intelligence and decision-making. Fraud detection requires querying millions of historical records, identifying behavioral patterns, and running complex analytical queries - all hallmarks of OLAP (Online Analytical Processing) workloads suited to a data warehouse. It does not perform simple transactional inserts or lookups, which distinguishes it from OLTP applications.
An eCommerce site is an OLTP application focused on real-time transactions such as orders and payments, not on aggregating and mining historical data for analytical insight.
Concept tested: Data warehousing vs OLTP application classification
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
Topics
Community Discussion
No community discussion yet for this question.