Question

definition

integrated, subject oriented, time variant, and nonvolatile collection of data usually read only db optimized for data analysis and query processing requires time $$ and managerial effort

choose an answer

data lake
database
data warehouse
data mart

Explanation:

Analyze the definition characteristics

The prompt defines a system that is "integrated, subject oriented, time variant, and nonvolatile." These four specific characteristics (subject-oriented, integrated, time-variant, non-volatile) are the classic, formal definition of a data warehouse as established by Bill Inmon.

Compare with the given options

• data lake: A raw repository of structured, semi-structured, and unstructured data, not strictly structured around these four characteristics.
• database: A general term, typically optimized for transactional processing (OLTP) rather than being specifically nonvolatile and optimized solely for analysis.
• data warehouse: Specifically matches the four-part definition and is optimized for data analysis and query processing.
• data mart: A subset of a data warehouse, usually oriented to a specific business line or team, rather than the enterprise-wide integrated collection.

Answer:

• data lake
• database
• data warehouse (Correct answer)
• data mart