nerdexam
CompTIA

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.

Data Concepts and Environments

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)
  • A
    3% (1)
  • B
    89% (32)
  • C
    6% (2)
  • D
    3% (1)

Why each option

For storing structured data about the entire company in a predefined data structure, a data warehouse is the appropriate repository.

AData mart

A data mart is a subset of a data warehouse, typically focused on a specific department or business function, not the whole company.

BData warehouseCorrect

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.

CData silo

A data silo is an isolated collection of data within a department, not an integrated repository for the entire company.

DData lake

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

#Data warehouse#Data repositories#Structured data#Data architecture

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice