Which option gives the most comprehensive description of what a data mart may…

Concept

A data mart is a subject-focused or department-focused analytical data store.

For efficient reporting, it commonly reshapes source data into query-oriented forms such as summaries, aggregates, and denormalized structures.

Application

• Summarised data: precomputed measures reduce repeated calculation during analysis.

• Denormalized data: combining related attributes reduces the joins needed by analytical queries.

• Aggregate departmental data: measures can be grouped for the business unit or subject served by the data mart.

Cross-check

Authoritative data-warehousing references describe data marts as department-focused stores that may be summarized and denormalized. Since each listed form can occur, the most comprehensive value is “All three listed data forms.”