DA0-002 · Question #108
Which of the following data repositories should a company use when structured data about the whole company needs to be stored in a predefined data structure?
The correct answer is B. Data warehouse. For storing structured data about the entire company in a predefined data structure, a data warehouse is the appropriate repository.
Question
Which of the following data repositories should a company use when structured data about the whole company needs to be stored in a predefined data structure?
Options
- AData mart
- BData warehouse
- CData silo
- DData lake
How the community answered
(36 responses)- A3% (1)
- B89% (32)
- C6% (2)
- D3% (1)
Why each option
For storing structured data about the entire company in a predefined data structure, a data warehouse is the appropriate repository.
A data mart is a subset of a data warehouse, typically focused on a specific department or business function, not the whole company.
A data warehouse is specifically designed to store large volumes of structured, historical data from various operational systems across an entire organization. It uses a predefined schema (e.g., star or snowflake schema) to integrate and organize data, making it suitable for enterprise-wide analysis and reporting.
A data silo is an isolated collection of data within a department, not an integrated repository for the entire company.
A data lake stores raw, unprocessed data, including unstructured and semi-structured data, and does not require a predefined data structure at the time of ingestion, unlike a data warehouse.
Concept tested: Data repository types, data warehouse characteristics
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehouse
Topics
Community Discussion
No community discussion yet for this question.